Forms-data entry

[Pawan]

Hello

I have two tables 'Customer" and "Hardware Customer". I want to create a
form to enter specific information in these two tables. However, my
requirement is:

There are few columns common in both tables like Name, address etc and other
columns are different. I want to create a single form where operator will
enter Name at one place only and it will get updated in both tables. Other
information needs to be updated in corresponding tables. e.g. operator will
enter "Hardware order" in form and it will get updated in "Hardware Customer"
only. all this need to be done in one form only.


Can anybody help me out.

Thank you in advacne

Regards,
Pawan

 

[Klatuu]

Is there any real reason to have two different customer tables? As you can
see, it will make life more difficult for you. You should combine the tables
into one. If there are some fields in one table that are not in the other,
add those fields to the table. Add a field to identify the customer type.
Then use one form and in the form's Current event, make the fields specific
to one customer type visible only when the current record is of that customer
type.