By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,266 Members | 1,816 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,266 IT Pros & Developers. It's quick & easy.

Problem with Multiple entries

P: 15
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.
Feb 16 '07 #1
Share this Question
Share on Google+
8 Replies


NeoPa
Expert Mod 15k+
P: 31,660
Firstly, you should visit (Normalisation and Table structures) to get an understanding of how tables should be laid out and how they should store the data.
Transferring data remotely is another issue entirely.
Sending the whole database backwards and forwards does not sound like much of a solution to me.
I normally create a Back-End database with just the data tables defined and send that one backwards and forwards between the sites.
It is important, in these situations, that the Back-End database is Compacted and zipped up before sending.
Feb 16 '07 #2

P: 15
I read the Normalisation and Table Structures Guide and I understand where I started to go astray with this. Was just hopping someone knew an easier way to set it up for the data collection aspect. Thanks for the advice.
Feb 16 '07 #3

NeoPa
Expert Mod 15k+
P: 31,660
Sharing data in this way is not a simple situation.
The best method for you depends heavily on a number of matters, including your experience using Access and the data that you're trying to share.
My solution (outlined in post #2) is what I generally use, but may not be the most appropriate for you.
Feb 16 '07 #4

P: 15
My experiance with Access is vert limitd at best. I took 1 5 week basic class and in it we created a few very simple DB's. What I am trying to accomplish is to create an asset list of all the equipment in each office. What I have done so far is create a DB with 6 tables. In each table I singled out 1 field that is unique to that table as my primary key and included an Office ID field which is the primary key in my first table. But now the problem I have is how to get the values entered into the DB. I have about 2000 offices around the US and I was kinda looking at the Html idea as a way to have my techs enter data and then bring that into the DB. But like I said with 2000 offices and each having 5 to 30 computers it gets really difficult to send that amount of emails and not have something go terribly wrong. I know that what I am trying to do is way out of my league right now but we have to start somewhere so any input is greatly appreciated.
Feb 16 '07 #5

NeoPa
Expert Mod 15k+
P: 31,660
Sounds like you've got yourself a pretty big problem there.
How about you start out by posting your table MetaData in the following layout.
Expand|Select|Wrap|Line Numbers
  1. Table Name=tblStudent
  2. Field; Type; IndexInfo
  3. StudentID; Autonumber; PK
  4. Family; String; FK
  5. Name; String
  6. University; String; FK
  7. Mark; Numeric
  8. LastAttendance; Date/Time
Feb 16 '07 #6

NeoPa
Expert Mod 15k+
P: 31,660
Actually, HTML is probably a better idea if you can get it to work.
You may want to post a question on this in HTML / CSS
Feb 16 '07 #7

P: 15
Thanks for the help but I think I found the simple solution I needed. I am just going to setup a few workstations with Office on them and have my techs remote in and fill out a spreadsheet for each office and then I can import those into the DB. Has worked so far in my test run.
Feb 16 '07 #8

NeoPa
Expert Mod 15k+
P: 31,660
Thanks for replying.
Yes, that was one of the ideas I was thinking of when posting #4 earlier. If that's a way you're comfortable with, then good for you.
If you have any difficulties with it please come back for help :)
Feb 17 '07 #9

Post your reply

Sign in to post your reply or Sign up for a free account.