Hi
I have a database of 7 tables, one master table holding all the transactions and 6 tables used for lookups.
When I try to edit a record, the record displays as the numbers held in the master table, these numbers are ID numbers for all the detail held in the lookup tables.
I would like to be able to show the detail from the lookup tables on the edit page for the main table.
I have tried including the fields I need to make the teacher and pupil names from the teacher and pupil tables, all that happens when I come to save the record is a 256 error
what I need to do is open the record for editing, set some empty field values to be the same value as some of the existing fields in the same record.
I then need to look for the value of one field in another table, get the associated record in the second table, retrieve the data from a different field in that record and look in a third table for the value I extracted from the second table. Once I have found the record in the third table, I need to extract the value of the index for that record and set it to be the value of the record I first opened.
I have tried to fiddle with saving old data in another table event, I have tried looking up values in another table, and boy, I am now really stuck and September 4 approaches.
I could do with some more of this forum's good help please.