Been trying to find info about this but it's hard to find the exact question I have, especially since, being in Sweden, the program and help file is in Swedish.
I'm using Access 2007 and I'm supposed to make a database. What I'm wondering is the following: I have a bunch of tables such as Customer and Customer Group.
Customer contains 2 fields whose data are to be manually entered, no problems there. But the other 4 are foreign keys from other classes such as Customer Group and Seller.
Having these fields show up as Customer GroupID, SellerID etc. is not what I need. They need to display the choices actually stored in those classes so that in the Customer form, you choose what to put in those fields from a drop-down list.
How do you set it up like that? The relations are already in place.
I'm using Access 2007 and I'm supposed to make a database. What I'm wondering is the following: I have a bunch of tables such as Customer and Customer Group.
Customer contains 2 fields whose data are to be manually entered, no problems there. But the other 4 are foreign keys from other classes such as Customer Group and Seller.
Having these fields show up as Customer GroupID, SellerID etc. is not what I need. They need to display the choices actually stored in those classes so that in the Customer form, you choose what to put in those fields from a drop-down list.
How do you set it up like that? The relations are already in place.