Originally Posted by
Gicu
The Geneesmiddel field should go in the table with the entity it describes; if it is associated with a particular barcode it should be in barcodes, but if it is associated with a knmp number (meaning you can have multiple barcodes with the same Geneesmiddel and same knmpnumber) then it should be in Overzichtstabel. As a general rule you don't want to duplicate fields across tables, you can bring them together using queries.
For the two subforms make sure they are linked properly (look at the child/master fields in the property sheet of the subform controls, they both need to be linked by the knmpnumber fields) and change the default view of the subforms to datasheet.
Cheers,
Vlad
what do you mean exactly. i tried putting this in the rowsource:
Code:
SELECT Barcodes INNER JOIN Overzichtstabel ON Barcodes.KNMPNummer = Overzichtstabel.KNMPNummer SET Barcodes.Geneesmiddel = [Overzichtstabel].[Geneesmiddel];
doesnt work.
i can make a query to fill out the field but then the tables will contain duplicate data right