Access 2007 question?

[NewOrder]

is it possible..



i joined a relationship between a few tables.
i put in my main table a key on the membershipID and then connected that field with the fields in each table (each field was named membership)

now when i go to view the date in the view, all the data under the column membership in each table is empty...

is it okay to leave it empty or is it incorrect

[RuralGuy]

Something is wrong. You should also name the MembershipID field the same in each table to eliminate confusion.

[NewOrder]

Something is wrong. You should also name the MembershipID field the same in each table to eliminate confusion.

above main table, below simple table

[RuralGuy]

Sorry but that is not very helpful for me. Do you have Referential Integrity enforced on all of your relationships?