job work tracker db help required

[madroamer]

hi

i am new to access. made a basic database to track job works and customer. issue is

1) job creation form doesnt let me create new jobs. i removed primary key too (but primary key req to avoid duplication)


2) single form itself cudnt capture multilple jobs. (though not major requirement but if have it will be easy to add multiple jobs in a single job creation menu)
3) form doest clear off post creation and cudnt create a clear form too as have used comboboxes to retrieve data from master db in forms. found some tutorials and used those codes from forum they dont help. removed the codes in the shared file while psting here.

pl help to make this database work.

[Bulzie]

Can you post a screenshot of your tables or give some samples of the data in each table?

Would think you have a tblCustomer with 1 unique record per customer and tblJob which links back to tblCustomer using CustID or whatever unique value for each.

[aytee111]

Made some changes to tables, naming conventions, forms.

[madroamer]

Made some changes to tables, naming conventions, forms.

Tks a lot man will check and revert

Sent from my DUK-L09 using Tapatalk

[madroamer]

made some changes to tables, naming conventions, forms.

tks u made complete change that i cudn grasp fully how to proceed. Plz chk pm. Need your assistance