I would rather just copy/modify a sample database than try and program one from scatch
I am looking for a
customer main table
When I select a customer i can assign certain products to that customer and the main table and form will work out the total price
table of customers
name addresss...
products
product code, description, price ... etc
i want to be able to search for a string ie which would included in the product description maybe using some wildcard code *samplestring*
Up will pop up all the likely products
I pick the product and these are assigned to the customer i have in the open table/form
There must be sample databases like that out there
I can customise it if i can work out how to do the data transfer from
product to customer
or
subform to main form
any ideas?
Dec