Howto add new record to form with related tables

[JrMontgom]

I have a query which is related by the ield contributorID for example Contributor table >>Address table>>PhoneNumber table>>Email table>>webURLS table. I can view the resulting data in the new form created using the query but I can't seem to get a new blank record for this form. I have set the DataEntry to Yes. Any help would be appreciated as it appears a simple problem but ....

[ItsMe]

Have you tried opening the Query Object in datasheet view? I am referring to the query that is the RecordSource of your form. It seems you created an non-updatable query. While in DS view of a non-updateable query, you will not be able to add records.

[Missinglinq]

I'm pretty sure that ItsME is correct, here. The general rule-of-thumb is 'one Table/one Form,' as Forms based multi-table Queries will very often be Read-Only.

The thing is that it looks like you've created the problem by taking normalization way too far! In most cases a person will have a single address, phone number, email and web address, and these should be included in the Contributors Table. Even if a contributor had several phone numbers, I'd be apt to include a couple of extra Fields in the Contributors Table to hold them.

Separate Tables are called for when a given data component can have an infinite number of possibilities, if you will, that cannot be forecast in advance. If, for example, you needed to keep track of all contributions made by a given contributor, then you would need a separate Contributions Table, with contributorID as its Foreign Key. You'd base a Form on this Table, then use this Form as a Subform on the Main (Contributors) Form. You could then track each contributor, whether they made a single contribution or a hundred.

And...you could add New Records or edit Existing Ones...which I'm sure you cannot do now.

Linq ;0)>

[JrMontgom]

The Address table and the phone table have multiple records for one contributor ID in tblContributor. SO if I want to add records to this related set of tables then I must add data to one relationship for example tblContibutor>>tblAddress then do for tblContributor>>Phone etc. IS this correct? So I can create a form linking related tables but I can't update the data

[June7]

Right, main form bound to tblContributor and subform(s) for the dependent records. Can arrange the subforms on pages of a Tab control or use Navigation form (I don't like it and never used it but you might like).

[JrMontgom]

Right, main form bound to tblContributor and subform(s) for the dependent records. Can arrange the subforms on pages of a Tab control or use Navigation form (I don't like it and never used it but you might like).

Thanks or the help and by the way I have a Contributions table set up relationally as suggested by Missingling. Once again thanks for the input.