Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

In your first table you only need the categories so CategoryName (ie:RPG) will be unique & set as primary key. In second table names are not unique so set a numeric auto field as primary key (creates uniqueness). Then a field with GameCategory (ie: RPG) and other fields as wanted. Then create a relationship with CategoryName in first table to GameCategory in second table (one-to-many relation). Do that from main Base screen Tools->Relationships. With that you can use form wizard (or design your own) to create entry & display forms.