P
pakerly
Hello, I am wondering if it is relatively easy to accomplish this?:
I want to make a form with following into:
ACCOUNT NUMBER:______
Product:________
AMOUNT:______
I want to store the results in a table called productusers, that has:
ACCOUNT NUMBER
NAME
ADDRESS
CITY
STATE
ZIP
PRODUCT
AMOUNT
and I dont want to enter such things as NAME, ADDRESS, CITY, STATE,
ZIP on the form, but if they exist based on account number in another
table (users), i want to fill that info in both in the new table and
on the form when they hit tab or click in the product field...And
finally have an ADD button that puts all of this into a record in the
new productusers table
If the users account number does not exist in that other table or
there is no address info than dont transfer to this new table. How
would I do something like this?
I want to make a form with following into:
ACCOUNT NUMBER:______
Product:________
AMOUNT:______
I want to store the results in a table called productusers, that has:
ACCOUNT NUMBER
NAME
ADDRESS
CITY
STATE
ZIP
PRODUCT
AMOUNT
and I dont want to enter such things as NAME, ADDRESS, CITY, STATE,
ZIP on the form, but if they exist based on account number in another
table (users), i want to fill that info in both in the new table and
on the form when they hit tab or click in the product field...And
finally have an ADD button that puts all of this into a record in the
new productusers table
If the users account number does not exist in that other table or
there is no address info than dont transfer to this new table. How
would I do something like this?