Newbie needs help with database!!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I am trying to make a data base to capture some serial numbers of kit.

I need to have the branch name and branch number

Each branch has mutiple bits of kit, all the serial numbers need to be
recorded.

I want this to be filled out in a form to make input easier.

I know what branches there are and how many bits of kit in each, is there a
way i can relate this so when i enter for example branch 1234 in my form, it
knows there are 10 bits of kit and has a space for each serial number?

Thanks
Matilda
 
I should also mention that each kits serial numbers need to be recorded
against the kits position, eg counter 1 - counter 20.

Thanks
 
Hi

I am trying to make a data base to capture some serial numbers of kit.

I need to have the branch name and branch number

Each branch has mutiple bits of kit, all the serial numbers need to be
recorded.

I want this to be filled out in a form to make input easier.

I know what branches there are and how many bits of kit in each, is there a
way i can relate this so when i enter for example branch 1234 in my form, it
knows there are 10 bits of kit and has a space for each serial number?

Thanks
Matilda
Click to expand...

What you should *start* with is identifying the Entities (real-life
things, persons or events) of importance to your application: the ones
I see here are Kits, Bits, and Branches (though I'm not at all sure
what you mean by a "bit" in this context). Each type of Entity gets
its own table.

Then you need to identify what each entity has as its Attributes:
specific chunks of information that you need to record. These might be
the branch number, the branch name, other info about the branch
(address?); the kit serial number, etc.

Once you have the Tables - the foundation of your application -
correctly designed and built, *then* you can start thinking about
Forms: but it's premature to build your forms before you have the
tables set up correctly. When you do, I can easily see a Form based
on the Branch table, with a Subform based on the kits table, into
which you can enter information about each kit. It would be easy to
have the serial number automatically assigned.

John W. Vinson[MVP]
 
Back
Top