Input Form to two tables

[SteveD]

Hello People,

This is really frustrating....
I have a form based on one table which will be used as an input form to enter new records and edit records.
While they are entering new records to this table I also want, on the same form, a way for them to enter image refs associated with the particular record (image refs being stored in another table). Therefore you have a one to many relationship between the main table and the images table using the field Campaign ID.
I've set up a subform for this, it shows the related records, however if I want to add new image refs onto the subform I keep getting an error message: Link Master Fields Property has produced this error 'The object doesn't contain the automation object 'Marlketing Communications'
(Marketing communications being the name of my main table)
My question is can you therefore only use subforms for displaying associated records-can you not also use them for inputting associated records?

Thanks in advance

SteveD

 

[Rich@ITTC]

Hi Steve

Subforms can be used for inputting data as well as editting and deleting data. You may need to check a few things, for example:

1. Is your subform linked to your main form using the correct foreign key/primary key? The Child/Master links should use the same field - eg. CustomerID. This would be the Primary Key in your main table and the foreign key in your child table (the table the subform is based upon).

2. Is your subform drawing directly on the child table or on a query based on the child table. If it is based on a query what happens when you run the query? Do you get an empty line at the bottom of the records with an asterisk in the record selectors - this means a new record can be added. If not, then this query needs to be examined as it would seem to be a "non-addable" query. Perhaps some fields from the underlying table have not been added to this query (in particular required fields) or perhaps the query is drawing upon more than one table and it is this link that is causing you a problem.

3. Check the settings for the subform as an object itself - does it have the settings for Allow Edits, Allow Additions etc set to Yes. If the subform is set to Yes then check the text boxes/fields/combo boxes - are they locked, etc.

4. Check that the subform has all the fields as text boxes/combo boxes etc that are needed.

HTH

Rich Gorvin

[This message has been edited by Rich@ITTC (edited 08-01-2001).]

 

[SteveD]

Thanks a lot for the reply Rich,

I'll check out all the things you mentioned. At least I know it's now possible!
(This forum really is a life-saver!)