I want to create a data base for my filing. need 2 tables.
Table 1 : id no (primery key), file name
Table 2 : id no (foreign key) and auto number, task name
id no. in table 1 to table 2 should be one to many. In table one each record I want auto number.
For this purpose what is data type of table 1 id no. field and what is data type of table 2 id no.
Please comment.