Table Structure Query

[bach]

I am creating a little database for members and there role, does this structure look write.

If so I can't seem to create a form that will allow me to entere member details and select a role name and link it to though the tables.

Would appricate your help advice!

 

[Pat Hartman]

Can a member really have more than one title? If so, add RI to the relationship. If not, move the TitleID into the Members table and delete the existing relationships with the TitleMembers table and then delete the TitleMembers table.

Since the member has two independent relationships, you need to use a main form (member data) and two subforms (role data, title data).

 

[bach]

Thanks

Pat,

Thanks for your reply, I have removed the middle table for the Title and inserted a field into members table to link to the title table.

I will have to give the form another go.

Thanks.