Hello Good Evening,
I Did development in Access 7 years back, now In my project I need to develop few forms
Can somebody please advise me or guide me to do this request
1) basically we have 2 tables in SQL server 2010(we are planning to move them to ACcess) for example first table is Customer (CustID, CustType, Age) second table is CustomerContact (CustID, Email1, EMail2, City)
I need to create a access for to insert data to Second table (but on form I need to show first table values in combobox)
so in my form I need to have Combobox (for table1 values to display) CustID, Email1, Email2, City text boxes
the combination of first table 3 fields (Custid, Custtype, Age) need to be populated as a single value per row in combobox when a user selects value from combobox then custid text box
will have the selected value Custid and user manually enters remain text box values(Email1, Email2,City) then when they click on insert button it should insert data to second table.
please guide me on any materials etc... Please please
Thank you very much in Advance