G
Guest
I am looking for assistance with what seems very basic, but I cannot seem to
understand, relationships between multiple tables. I always end up making a
DB with one huge table and running all queries / reports from one table. I
doubt this is the best way! I always assign a "primary key" to one item per
table but in the relationships field I have no idea which should be left,
right, one, many, referential integrity, whatever. Somewhere in the training
classes (Access 2000,L1 and L2) the instructors glossed over these topics and
I am lost. In my forms I keep getting a message that my input fields "control
can't be edited, it is bound to unknown field "fieldname".
Please help, I am sure this is very basic for many of the experts here, and
I appreciate any assistance. TC
understand, relationships between multiple tables. I always end up making a
DB with one huge table and running all queries / reports from one table. I
doubt this is the best way! I always assign a "primary key" to one item per
table but in the relationships field I have no idea which should be left,
right, one, many, referential integrity, whatever. Somewhere in the training
classes (Access 2000,L1 and L2) the instructors glossed over these topics and
I am lost. In my forms I keep getting a message that my input fields "control
can't be edited, it is bound to unknown field "fieldname".
Please help, I am sure this is very basic for many of the experts here, and
I appreciate any assistance. TC