relationships

[yessir]

I have 2 tables, 1 containing staff names and numbers, another containing staff numbers and other info...

when i create the relationships, they are 1 to 1,

y not many to 1?

 

[yessir]

NM

I guess the wuestion now is how come the staff table cannot have more than 1 subform?

say 1 for phone data collection
and 1 for program notes

 

[al718]

the relationship needs a primary or indexed key in order for it to be a one to many relationship

(primary key on the one that you want to be the one table)

then u can make as many other "many tables" to be sub forms as you like

 

[yessir]

right

but it won't