C
ChuckW
Hi,
I have an access database that contains transactional tables which I cannot
alter. There is a table called invoice. This has ClientId, ClientName and
ItemNumber. The ClientID is a ten digit number while the ClientName is a
business name. There are no extra fields that I can use in it. I want to
create a form that will enable the staff to keep track of registration. A
registration is initiated when an invoice on a client is created with the
itemnumber being College. Right now, people are keeping track of attendees
using a spreadsheet but I want to create a table that contains these names
and somehow links to the Invoice table. I can create a data entry screen
that enables the staff to add people to these College events. I want it to
read the invoice table for item=College and then be able to add names that go
to a registration table. What is the best way to set this up?
Thanks,
I have an access database that contains transactional tables which I cannot
alter. There is a table called invoice. This has ClientId, ClientName and
ItemNumber. The ClientID is a ten digit number while the ClientName is a
business name. There are no extra fields that I can use in it. I want to
create a form that will enable the staff to keep track of registration. A
registration is initiated when an invoice on a client is created with the
itemnumber being College. Right now, people are keeping track of attendees
using a spreadsheet but I want to create a table that contains these names
and somehow links to the Invoice table. I can create a data entry screen
that enables the staff to add people to these College events. I want it to
read the invoice table for item=College and then be able to add names that go
to a registration table. What is the best way to set this up?
Thanks,