I have 3 tables A B C. Table A and B and C have field ID. Table A is the main table. Table B and C has a relationship with table A. B:ID=A:ID and C:ID=A:ID. Now i want to automatic fill field in table B with values from table C but not only based on ID. There are fields in the C table: Date, ID, Name of protocol. There are fields in the B table: Seal Number, ID, Seal owner. But now i have to add in table B field Name of protocol and Date. And also in one ID i have several seals. I wan to enter DATE in B and automatic get Name of protocol from C. I tried with if function but when i have several dates and protocols in one ID In B fill only first one.
I hope I have explained things well