MS Access: Subforms & Relations?

Question

I have a database that I'm working on for free (nobody would hire me as a DB programmer with my dim knowledge of Access).

In any case, I have what seems a simple duty: Make a DB with records of names and other personal info (easy) and each record should have another dimension which can list the employers which that person had, and other info about that job (the difficulty).

I have created a subform and things look good except if I try to add a new record (besides the existing first record) in the subfield I get an error about indexes and relations. Every little bit of literature that describes these relations sucks. I can only understand common fields. When it comes to a "one-to-many" or whatever I can't figure.

Please help while I wait for my membership to an Access forum to come through. (It's Friday and I wanna make a lady here smile before the day is out) ;)

Answer 1

This is going to come down to table structure. I would set it up something like:

tblEmployees - // Employees

employeeID

employeeFname

employeeLname

etc...

tblEmployers - // Employers

employerID

employerName

etc...

tblEmployerEmployees - // Linking employers to employees

tblID

employerID

employeeID

In this way, one employer can have several employees associated with them and one employee can have several employers associated with them.

At this point its just a matter of linking your subforms Master & Child IDs to your main forms record source ID.