I have not been able to construct lookup tables for my Access form entries. I am able to do lookups by having a one to many relationship in the query but that only gives me the information if I know the name or codes.
Does anyone have an example of how to do a lookup table for a form or query?
I have an employee name that I want to enter and have the table fill in wage rates, but I want to be able to pick the name from a table instead of a list or drop down box.
Thanks.
Does anyone have an example of how to do a lookup table for a form or query?
I have an employee name that I want to enter and have the table fill in wage rates, but I want to be able to pick the name from a table instead of a list or drop down box.
Thanks.