Form

[Hong]

Hello,
I have a very simple database, only one table which has customer name,
account1#, account2#, account3#, and notes.

I want to creat a form, with only customer name as a combo box, when I click
on the pull down arrow, I can pick the customer name, and then show the
relate accout information.

But I also can add new customer, which I can add the new customer account.

Is that possible, please help.

Thank you!

 

[John W. Vinson]

Hello,
I have a very simple database, only one table which has customer name,
account1#, account2#, account3#, and notes.

What will you do when you need a fourth account number?

What will you do when two different customers (husband and wife say) share the
same account?

What will you do when you want to search for a particular account number? Use
a more complex query searching all three fields?

Sorry, but your table structure IS WRONG. If you have a one to many
relationship you need *two tables* in a one to many relationship:

Customers
CustomerID <Primary Key>
LastName
FirstName
<other biographic and contact information>

Accounts
AccountNo <primary key, unique account number>
CustomerID
<other info about the account itself>

Or if two customers can have the same account, you may need *three* tables.

I want to creat a form, with only customer name as a combo box, when I click
on the pull down arrow, I can pick the customer name, and then show the
relate accout information.

The Combo Box toolbox wizard in form design has an option "use this combo to
find a record." You'ld want separate controls - textboxes say - to enter new
customer data. If you take my table design suggestion you could use a Form for
the customers, with a Subform for that customer's accounts.

But I also can add new customer, which I can add the new customer account.

Is that possible, please help.

Possible and easy (it helps if you start with a proper table design though!)

For some tutorials in how to use Access productively see

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

John W. Vinson [MVP]

 

[Hong]

Sorry! I didn't explain clear.
It's one customer has different courier account, for example: UPS, Fedex, or
DHL, they can have only one or all. I am trying to create a database, so make
it easy to enter information and pull the information.

Thanks.

 

[John W. Vinson]

Sorry! I didn't explain clear.
It's one customer has different courier account, for example: UPS, Fedex, or
DHL, they can have only one or all. I am trying to create a database, so make
it easy to enter information and pull the information.

That's what I'm trying to help you to do. Please reread my reply and take a
look at the tutorials I cited.

A properly normalized two-table system will do precisely what you're asking to
have done.

John W. Vinson [MVP]