Maybe I should give more info on what I'm trying to do.
I have 3 tables- Badgeprofile, FMPSCode, and Prepay.
Badge profile contains: BadgeID, FirstName, LastName, FMPSCOde, and FMPSDescription.
FMPSCode table contains: FMPSCode,FMPSDescription, BreakfastCost, and LunchCost.
Prepay table contains: BadgeID, DateofPrepayment, PrepaymentAmount, and Balance.
The form I want to create is for the user to record meal transactions. When the user enters a BadgeID, the FMPSCode,FMPSDescription, the balance for that BadgeID and the cost of the meal(breakfast or lunch) which it gets from the FMPSCode table, is autofilled. I also built an expression to subtract the cost of the meal from the Balance.
All this I would like to append to a table I call DailyActivity.
I hope this helps give a better idea of what I'm trying to do.