Enter new record w/ multiple corresponding values from other table

I have 2 tables; 1 for acct mgr names/addresses from my company and 1 to
enter all of our customers.

My problem is that I want to create a form where I can enter an acct mgr
name/address from my company and then select (maybe from a subform) multiple
customers that this acct mgr is assigned to, so that it maybe (?) duplicates
the acct mgr information and creates a new record in the table everytime
another customer name is selected.

Is this possible?

Use two tables - Company & Customers - CompanyID, Autonumber as primary key &
CompanyID, Number - Long Integer as foreign key. Set a one-to-many
relationship with referential integerity and cascade update.
Then use a form/subform for manager/customers with Master/Child links set to
the CompanyID.
--
KARL DEWEY
Build a little - Test a little


"jmjlmad" wrote:

I have 2 tables; 1 for acct mgr names/addresses from my company and 1 to
enter all of our customers.

My problem is that I want to create a form where I can enter an acct mgr
name/address from my company and then select (maybe from a subform) multiple
customers that this acct mgr is assigned to, so that it maybe (?) duplicates
the acct mgr information and creates a new record in the table everytime
another customer name is selected.

Is this possible?