Problem: I would like to correlate a table of attachments (made however with hyperlinks) between two different tables, I explain by first making the example with one.
I have a table (tblDataA) that contains various fields, although to simplify in the example I only put primary key (ID_DataA) and short text (Description).
This table should contain groups of attachments (hyperlinks).
I made them with a tblAllegati table and a tblAllegato table with a one-to-many relationship.
In addition, tblDataA is also corrected to tblAllegati with a one-to-many relationship.
So it works very well for me because if I create a mask with the wizard and insert tblDataA, tblAllegati and tblAllegato I get a mask that for each tblDati record allows me to insert (new) groups of tblAllegati records with relitive tblAllegato records linked. I can create and see everything from the created mask. The wizard already puts me the sub-masks of tblAllegati and tblAllegato.
If I wanted to do this for a second table tblDataB, I could replicate the schema with two tables (tblAllegatiB and tblAllegatoB) so I could create a fully functional mask as in the case of only table tblDatiA.
I wonder, though: is there a way to bind tblDatiB to a unique tblAllegati?
I tried creating a mirrored tblDatiB table and adding a numeric field ID_DataA to tblAllegati, creating the relationship:
but it doesn't work because when I enter the data with the mask done before, I get the error 'Unable to add or edit record. A related record is needed in table "tblDataB'' '.
I know that "he" is right, however, is there a way to have a tblDataB and related form, which works for me as it did when there was only one table, but which always "fishes" from a single table of attachments?
Thank you very much... Be patient for my poor English.
Paolo Ferraresi, Italy.