I'm trying to make a form that has information from multiple tables and I don't know how.

[MOB]

Hello All,


So to be exact I'm building a database for a food company (school project) and I need to make it so my forms can be edited and what not.
I have the Clients which could have allergies and food preferences, 1 Client can have multiple allergies \ preferences and most do.

Now the question is how do I make a form that allows me to see all the alergies and how can I see all the allergies on a form, and how can i edit, change, etc... in the form.

If you have questions please ask I'm available.

Another question is that I have a Field called Sex# which is either 1 or 2. 1 = Male and 2 = Female. How can I make a Field Sex which takes the information above and autofills to M or F depending on the number.

[Micron]

Best design for relating one record (e.g. a person) with many records (allergies) is to use a main form (person) subform (the many). You should have at least a table for persons, one for allergies and a junction table for persons/allergies. I suspect you're going to ask what a junction table is. Instead, do yourself a favour and research db normalization.

I don't know where you're located but a table field for sex/gender that can be only M or F seems quite archaic.