microcrafters
Programmer
I have a database that has the following tables
-Parts with the following fields
[item number], [description] , [systemID],[Type]
I want to create a form that will allow me to save both parts and assemblies in the parts table.
I created a lookup form where the main form uses a query to that finds all parts where the [Type] = System. then the form uses a subform that uses a query to list all parts that [systemID]=[ItemNumber]of the lookup field. then the subform is a datasheet with the item number being a lookup field that uses a query to show records where [systemID] is null. this far all works well. the problem i am having is that when i select a part that i want to add to this assembly i want the form to update the [SystemID]to whichever system is showing in the main forms lookup field. this is similar to adding items to and invoice by updating the invoicenumber field in the parts table. however the system keeps telling me "you can't assign a value to this object" then creates a new part with inly an ID and SystemID. any help will be appreciated
-Parts with the following fields
[item number], [description] , [systemID],[Type]
I want to create a form that will allow me to save both parts and assemblies in the parts table.
I created a lookup form where the main form uses a query to that finds all parts where the [Type] = System. then the form uses a subform that uses a query to list all parts that [systemID]=[ItemNumber]of the lookup field. then the subform is a datasheet with the item number being a lookup field that uses a query to show records where [systemID] is null. this far all works well. the problem i am having is that when i select a part that i want to add to this assembly i want the form to update the [SystemID]to whichever system is showing in the main forms lookup field. this is similar to adding items to and invoice by updating the invoicenumber field in the parts table. however the system keeps telling me "you can't assign a value to this object" then creates a new part with inly an ID and SystemID. any help will be appreciated
