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]
