Form using multiple tables issue

[cath_hopes]

Hi there!

I'm attempting an ambitious form or maybe its quite straightforward, perhaps someone can advise me please:

I am trying to create a powerful form that will have access to data from 8 tables. They are all interrelated via foreign keys and one to many relationships. 3 of these tables I wish to be amendable (create, amend and possibly delete). The remaining 5 tables I wish to be read-only.

To achieve this should I base the form's record source on a query that includes just the 3 tables I want to be amendable?
Any comments/ tips will be gratefully received.

Many Thanks,
Catherine

 

[boblarson]

You can use subforms for this and for the data you want to be read-only, you would set the subform's Allow Additions, Allow Edits, and Allow Deletions properties to NO.

 

[cath_hopes]

Thanks Bob,
I've been reading up on subforms and have begun building my mega form with all its subforms. So far so good though still a long way to go. I have set the Allow Additions, Allow Edits, and Allow Deletions properties to false as you suggest but for my main form and to occur only once the first subform has been selected. Seems to work ok too.