How to pick from 'either' list

[Brian Belliveau]

Greetings to all ...

I'm a relative newcomer to working with access ... much more experience with
excel ...

I'm building on the 'Time & Billing' template.

I would like to select a customer from one of two lists ... 'Contractors'
list is relatively static & 'Customers' is fluid, in that virtually each
customer is for one job only.

Alternately, is there a device to combine these into one list?

Thanks to all

 

[Arvin Meyer]

The "alternate" solution is the correct one. Make a single list and add a
column with the CustomerType, then filter the list by the type. If
necessary, add a table for the customer types and use the CustomerTypeID as
the column in the main table.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access