Apr 28 2004, 06:44 PM
I have a form that uses a subform as well, I need to have a field in the subform not only update the table it is attached to but also update the same field in another table.
Apr 28 2004, 06:58 PM
This sounds like a structural problem. I can think of no reason for duplicating a field in two different tables (other than a foreign key). What exactly are you trying to do? How do you know which record should be updated?
Apr 29 2004, 11:00 AM
it is a design problem, but I do not have time to redesign the whole thing.Basicly I have a form that a sales rep enters info, and the info in turns put data in the lot table, My task was to build another form for a differant department that will use the lot table to fill in the basic info, but also uses a subform to write data to another table, all the reports are written against the lot table, and I will be write new reports, however I need to have the data in both tables. The reason I did not just add all the extra fields to the lot table (which qwas my first choice) and be done with it, was because ofthe 255 field limit in access. To get around that, I used the lot table for the basic info, and used a new table "room" for the new info, there are however overlaping fields that need to both be updated.
Apr 29 2004, 11:05 AM
The question is ...
Do you have the time now to fix the application or do you have the time latter ...
A bad structiure is not good to create an application around ...
I recommend you fix your structure now or you will more than likely have many more problems with your design ...
Apr 29 2004, 11:15 AM
impossiable, not my design. I would be better off creating a whole new database correctly. I do not have the time to try and figure out how the other person did what he did and he no longer works for us
Apr 29 2004, 11:20 AM
Well then you can't expect us to add to the misery and bad design by attempting to fix problems that should not be in the first place ...
Apr 29 2004, 11:27 AM
no I didn't expect anything, I was only asking for help, and if it was possiable, if not tell me and I will move on, if it is possiable all I ask is how, I am not an access wizard
Apr 29 2004, 12:17 PM
Why do you feel you can't take a few extra minutes to get the structure correct? If you're running into the 255 field limit then you definitely have repeating groups and mixed entities. It may be possible to re-structure in the same amount of time it would take to build a workaround to your problem.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here