I am trying to create a DB in Access 2007 where the values in certain fields requires multiple entries.
I would like to send this DB out as an HTML to my techs and have them fill the information in.
The problem I am having is that I am having to create too many tables. I would really like to have no more then 3 or 4 tables.
I've been able to setup most of the tables so that each value has only 1 entry but when I get to the inventory tables that is just impossible.
Below is an example of one of the multi entry tables I would need.
So far I have set this table up as follows
Table Name : Computer Information
Field 1 : Office Number (Primary Key)
Field 2 : Computer Name
Feild 3 : Computer Serial Number
While field 1 would only have a single entry fields 2 and 3 would have between 5 and 30 entries.
While I could use the serial numbers as the key for this table I don't want to have to send tons of emails just to get the info from one office.
If anyone could give me some direction it would be greatly appriciated.