I have a material invoiceing program that consists of 4 databases as follows:
1. Customer File
2. Job File
3. Invoice Header File
4. Invoice line items file
These are all related one after the other in a one to many relation. Each customer can have multiple jobs, each job can have multiple invoices, and of course each invoice can have multiple items. Real simple so far.
These are on a tabbed form with embedded browses. The first tab has three browses to pick the customer, job, and invoice that you wish to work on. Then on the second tab is the invoice line items browse where you can add line items to the chosen invoice. Works great. I put a button on the invoice detail screen to print the current invoice.
Then I thought it would be helpfull to add a memo field to hold a description of the work performed so it would print on the invoice also. I added it to the invoice header database as there would only be the one description per invoice and added a field on the form where it can be edited. Now the trouble starts.
Anytime there are multiple jobs for a given customer, when notes are added to the memo field, that invoice is reassigned (the link field of the set definition is reassigned) to the first job for that customer which of course is incorrect.
Why does editing the memo field change the linking field information?? I can edit any other field on the invoice header and it makes no difference. I have noticed that if I edit the memo field with the memo field editor that works OK but not if I edit in the display field. Any ideas??
I've tried compacting the database, packing the files, reindexing, etc. but nothing seems to help. I could send the stuff if someone thinks they could figure it out??
1. Customer File
2. Job File
3. Invoice Header File
4. Invoice line items file
These are all related one after the other in a one to many relation. Each customer can have multiple jobs, each job can have multiple invoices, and of course each invoice can have multiple items. Real simple so far.
These are on a tabbed form with embedded browses. The first tab has three browses to pick the customer, job, and invoice that you wish to work on. Then on the second tab is the invoice line items browse where you can add line items to the chosen invoice. Works great. I put a button on the invoice detail screen to print the current invoice.
Then I thought it would be helpfull to add a memo field to hold a description of the work performed so it would print on the invoice also. I added it to the invoice header database as there would only be the one description per invoice and added a field on the form where it can be edited. Now the trouble starts.
Anytime there are multiple jobs for a given customer, when notes are added to the memo field, that invoice is reassigned (the link field of the set definition is reassigned) to the first job for that customer which of course is incorrect.
Why does editing the memo field change the linking field information?? I can edit any other field on the invoice header and it makes no difference. I have noticed that if I edit the memo field with the memo field editor that works OK but not if I edit in the display field. Any ideas??
I've tried compacting the database, packing the files, reindexing, etc. but nothing seems to help. I could send the stuff if someone thinks they could figure it out??
Comment