Foreign keys are other table's primary key, many of them are not regular automatic numbering Numbers, did not know what to do with the digital input, also particularly prone to errors,

CodePudding user response:

Table design inside a function, you can set to the combo box in check, the data source will be the main table, set the number of columns, column width, etc., so that you can choose when inputting data, generate the form in the future, when the field selection will automatically become a combo box, the book tell the general function Access or tutorial will say, you need to go to the groundwork,

CodePudding user response:

Ok, thank you for your reply,