Thanks again for replying to my request so promptly.
I have tried your suggestion, but am told by Approach that I am trying to create a circular join. CUSTOMER database is joined to PRODUCT and PRODUCT is then joined to WORKS ORDER. I cannot join CUSTOMER direct to WORKS ORDER.
Any further help...
I have databases joined as follows. CUSTOMER - PRODUCT - WORKS ORDER. Joins are both 1 to many.
I have a form based on the CUSTOMER database with a repeating panel which is based on the WORKS ORDER database. There is an order status field in the WORKS ORDER database, with possible values of...
Many thanks indeed for this tip. It has saved one of my colleagues an hour per week of tedious data entry !.
I'm an amateur programmer whose main job is sales director, but my Approach program has become an integral part of our business. There are only a few things that I can't get it to do (I...
My system produces multi-line invoices. The invoice value is a summary field. Invoice values are currently batch entered into a separate accounts package (Sage for Windows). Is there any way of exporting this data? Summary fields do not appear in the export dialogue box.<br><br>Many thanks...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.