How are ya AccessApprentice . . . . .
AccessApprentice said:
[blue]I want to enter the parent info from either form and have it synchronize the changes from form to form what is the best way to go about this.[/blue]
This dictates a form with subform, and if there linked properly, the rule is:
[blue]You can't add a record in a subform unless there's a corresponding Linked ID (usually primaryKey) in the mainform.[/blue]
This alone ties you to entering data in the main form first, or, [purple]you can't (shouldn't) enter data in the Child first.[/purple] If you do and try to save . . . . you'll get an error anyway!
[blue]These are the rules[/blue] and are in fact [blue]the proper way to enter data[/blue] in a main/sub form combination. Its not just you . . . [purple]
we all have to do it![/purple]
Now, you can program around this, but it would serve no real purpose. And having duplicate data in main & subform is not what a database is about.
Bear in mind . . . . you are the programmer, and there are times when you just have to exercise your power. For instance . . . . in no commerical DB that I've designed do I allow users to delete anything . . . espcially records. Its a pain and they all complain about it . . . . but [blue]it only takes that one unsatisified user to go in and delete everything . . . bada bing . . . baba boom![/blue] I have a pop-up that notifies the user to contact administration for this. Quite a few owners were against it, but over time they have been very thankful. I think you get the point.
[blue]Doing what you need to here, will save you alot of time & headache . . . . think about it . . .[/blue]
See Ya! . . . . . .
