I have to create a database. The data format is something like the following:
A (a1,a2,a3,a4) (for example A=shoe, a1=shoe lace, a2=insole , ...)
The problem is the number of input for each entry may differ from the others (there are 4 entries for 'A', 2 entries for 'B' and .... ) so I cant have a single table format for all of them.
I was wondering if it is possible to use an access database in which one table includes main entries (A,B,C,D here) while each row is connected to another table containing the sub_data?
I have attached a picture to make it clearer