Parent and Child record

M

Monica

H

I have created a parent and child relationship between Project records, where a project and be a parent or child to any to any other projec

i.e
Parent_Project_ID, Child_Project_ID both linked to the main Project table Project_ID

I have created a query which will allow a user to enter a record into the relationship table, however as soon as I add the main project table into the query and link it to Child_Project_ID, the query will no longer allow a user to create a new
record (i.e. so the user can see the detail of the child record on screen). I would like to be able to do this, so that when a user is in the main Project Form, they can add child project records via a sub form and veiw its details

Does anyone have any idea if this is possible
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding data to MS Access from csv file 0
Access 2013: Form problem in reading data tables; relationship one-to-one 0
form/subform-require at least 1 new subform record at data entry 1
Seeking suggestion for handling parent/child situation on continous forms 6
No Field Edit capability 3
How do I remove parent-child relationships in the parent table? 3
Filtering a table based subform 1
Relationship Help with Tables 1

Top