Need help with a form

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

Guest

I am new to developing a DB for my company - self taught and running into
trouble. We are trying to integrate our quote DB and accounting system and
we are there except for one item.

When we enter a quote in the system, we currently have to enter the Customer
#, cust. name, address, phone, etc. All of this data is stored in a table
already - isn't there a way to select a cutomer number and have the remaining
information fill in on its own?

I know this has to be possible - but i have done a lot of research and am
having troubles figuring it out. If you have suggestions, please don't
hesitate to email me @ (e-mail address removed)
 
There are a number of ways it can be done but proberbly
the easiest is to set up a main form and a sub form. The
sub form should be based on the table of the Customer
Details. On the main form you need a control to enter
the customer number, and on the sub form object set the
master and child links to the respective control names.
This way when a number is entered into the main form the
corresponding record will be displayed in the sub form.
 
I am new to developing a DB for my company - self taught and running into
trouble. We are trying to integrate our quote DB and accounting system and
we are there except for one item.

When we enter a quote in the system, we currently have to enter the Customer
#, cust. name, address, phone, etc. All of this data is stored in a table
already - isn't there a way to select a cutomer number and have the remaining
information fill in on its own?
Click to expand...

Well... DON'T.

In a relational database, you should never store data redundantly in a
second table. Your quote table should contain a customer number, and
NOTHING else from the customer table.

You can *display* the customer information; one common way to do so is
to base a Form on the customer table, with a combo box to find the
right customer, and use a Subform for the quotes table, using the
customerID as the master/child link field.
I know this has to be possible - but i have done a lot of research and am
having troubles figuring it out. If you have suggestions, please don't
hesitate to email me @ (e-mail address removed)
Click to expand...

Requests for private EMail support are considered impolite. If it's
worth my time as a volunteer to post an answer to the newsgroup, it
should be worth your time to come back to the newsgroup to read it.
I'm copying your EMail just in case, but please reply to the
newsgroup, unless you wish to initiate a paid consulting contract.

Note also that posting your EMail address on the newsgroups puts you
at risk - spammers routinely trawl the newsgroups for any valid email
addresses, and you WILL get spammed as a result.

John W. Vinson[MVP]
 
Back
Top