Multi-table form questions

  • Thread starter Thread starter Top Spin
  • Start date Start date
T

Top Spin

I have a simple database with just 2 tables for keeping track of tea.

The tea table has fields for the name, type, and other data.

The vendor table has field for name, address, website, etc.

The two tables are linked by the VendorId field, which is the primary
key in the vendors table and just a field in the tea table.

I want to create a form for data entry of new teas. I want the form to
only allow me to select from the existing vendors. Should I put a
listbox or a combobox control on the form? Is there some other way to
do this?

What can I do so that from that same form I can add a new vendor to
the vendor table and then have it available to select from when
entering a new tea?

Thanks


--
Running MS Office 2K Pro
PC: HP Omnibook 6000
OS: Win 2K SP-4 (5.00.2195)
Email: Usenet-20031220 at spamex.com
(11/03/04)
 
Look at the main form - subform setup in any of the template applications
and/or Northwinds.
This is a common strategy to show two related collections and permit
add/edit/deletion of either or both.
-Ed
 
Back
Top