Auto populating table

Discussion created by scarruth33 on Oct 23, 2015
Latest reply on Oct 25, 2015 by scarruth33

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.


Screen Shot 2015-10-23 at 1.37.57 PM.png

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?