I'm creating a database for my baseball cards. I have successfully created a conditional values table for one field but now I'm trying to do that for another field. The problem with this is that I don't have all the information for the fields and so I'm currently building the table with the information that I do have, but if the occasion arrises I want to be able to just type in the field and it create a new record on the other table. I hope that I have not been too confusing.
Ok so in the above layout, I currently have conditional values set up for Sport and Team, I want to do the same for Manufacture and Brand. As I stated above I do not have all the information for the table that will be associated with Man & Brand. Is it possible to be able to be entering data in this layout and it be entering data that maybe missing in the a related table?