Question table relationships question

[hunterfan48]

Ok, so Table B is related to Table A and they both have one field in common that distinguishes each record. But, when it comes to enter a new record, I can only enter it in the Table A table. Any reason how I can enable Table B to be able to also enter a record??

 

[ghodges]

not quite sure what u are saying.....

Table A and Table B are related with a common field ...fine
what kind of relationship (1 to many)?

I suspect that what you may be trying to do is cascade the tables.

when you look at table A, in the first column do you have a "+" sign if you enter any data in table A


Basically you are going to have to give a bit more detail so i can figure out what you are trying to do

Geoff

 

[hunterfan48]

one to many...ok here it is. I have two tables, Transaction ID and Card Transactions. Card Transactions has a field titled ID that uniquely identifies each record by a number for example, 0001, 0002, 0003, 0004, etc. As for the rest of the fields in the table, the fields jus describe the data. In that same table, I have a subdatasheet from 'Transaction ID' that lets me know which cards from my inventory were sold by way of the 'card id' field from my card inventory table.

anyways, so I am only able to enter a new transaction id in that specific field in that table. Even tho, the transaction ID table has that same field, it will not let me add a record with a new transaction number that hasn't been used yet in the card transaction table. it gives me the following error message...

"You cannot add or change a record because a required field is required"

 

[hunterfan48]

when you look at table A, in the first column do you have a "+" sign if you enter any data in table A


Yes, this is what happens.