Form with specific data 1

[davjr]

In my DB I have 2 tables "Customers" and "Job_Input"

The "Customers" table is updated daily and each customers is identified by a JobNo.

The "Customers" table is a contiuous form which displays todays customers, each customer has a command button ("Update").

The objectives are to:
1. Open form "Job_Input" and display customers details based on the JobNo.
2. Once details are entered into form "Job_Input" click on command button "Save" which will save data in "Job_Input" and delete record from "Customers" table

I have read through and tried many threads but still can not achieve my objectives.

Can anyone help with this.
Thanks
Davo

 

[fneily]

Not to sure why you can't achieve this.
Create two forms. The main one will be your continous form with the command button in the detail section that will open the second form. If you use the command button wizard and follow the steps, you'll see an option to open to specific records. Select this option.
The second form is your job entry form with a save button in the form footer section.
When you click on the command button next to any customer, it'll show the corresponding child records.

"delete record from "Customers" table"???? What are you doing? The customer table is the parent table the job_input is the child and they should be in a one-to-many relationship with referential integrity turned on. Have you study Normalization? You should have no duplicate data in the tables.

 

[davjr]

fneily

Thank you for your prompt reply

It's now obvious that I have been approaching this problem incorrectly

Thanks again
Davo