Unanswered: FoxPro - passing parameters between forms
I am new to FoxPro and I have written processes etc in the past, but never designed forms...
Currently I have a form that contains two tabs, the first is "Maternity Details" which includes a list box with an employees maternity details. When you select an item in the lsit and enter tab two, it then shows the breakdown of the selected maternity period - Start date, end date, week due, actual DOB, etc.
Now, due to a change in the way maternity leave works, we have to include information about KIT (Keep In Touch) days. This information is stored in a new table called "KIT".
KIT(UniqueID, ParentID, DateFrom, DateTo)
Where ParentID is the link between maternity and KIT.
So I have the challenge of creating a form to contain KIT days for a selected maternity period. After much playing around I have come to the conclusion that a new form is probably the best way forward (not a new tab).
I want to open the KITDays form to show only the records relating to the Maternity (by passing the ParentID to the form?).
Feel free to ask for any more information if needed. Ta!
I simplified my problem a wee bit so I apologise for the confusion.
the relationships are as follows: One Employee can have many Maternity records One Meternity record can have many KIT records
Employee.Unique_Identifier = Maternity.Parent_Identifier
Maternity.Unique_Identifier = KIT.Parent_Identifier
(The keys are automatically generated when the tables are created so no, they're not perfect, but they work).
Yes, the existing UI is based on tabs, but the meternity forms first tab contains a list box with all the maternity instances, and the KIT will need this too. I didn't want to have a Listbox > select item > another lsitbox > select another item on the same form, but yes, it could be done this way.
Currently I am struggling with the 3 tier relationships on one form, hence my idea to create a new form with only a 2 tier relationship.
Apolgoies for my... *scribbles out poor (backspace?)* Sub-par answers but my head has been aching an aweful lot over this problem as of late.