I have a form with several different fields.
I have a table with a list of numbers. (Lets say 1-10). Each number has a
corresponding date and type. (tblDailyClaimDate)
I also have a table with the 5 fields listed below. (tblData)
The form contains the 5 fields above.
I want to be able type in the number and have the date and type auto populate based on the table tblDailyClaimDate and then I fill in the rest of the fields and it write to tblDate.
Is this possible?
I have worked with Combo Boxs populating lists based on another combo box, but not something like this. I am not sure if it works the same way...