I have a form called "HelpCalls" which already has numerous fields..it has the following "fixby", "fixdate", "fixtime", "problem" & "resolution" fields plus many more ..however one tech may work on the call, do his part and time & his resolution and it needs to be reassigned to someone else..I created another table & form which I want to link by "helpno" which would have of the same basic fields fixby, fixdate,resolution ect. .I want to call my new form "trail" from a button on "HelpCalls"...the question is how do I call my new form "Trail" and have it do the following......I want it to pop up at the bottom of my screen, I want it to first check if any other "helpno" match from "helpCalls" "helpno"...if I have matching calls I want it to show them to me and make it so I can add another one at the bottom of the list...if not matched ...then I want to put my "helpno" from the HelpCalls form into the field "helpno" on my new form "trail" and be able to enter data right then...hope this makes sense...the call may be reassigned two or three times so I created a new table so as to not overlaod my original helpcalls table...need help soon!
Calling a form, check for matches,add new user
- Thread starter pattyt
- Start date
Fornatian
Dim Person
- Local time
- Today, 06:02
- Joined
- Sep 1, 2000
- Messages
- 1,396
This is a classic normalisation situation.
Because there are numerous 'helpers' for each help request it is necessary to split away the 'helper action' from the 'help request' itself by storing the data in a separate table.
The structure you need is two-table like so:
tblHelpRequest: Fields
HelpNo(Primary Key)
RequestDate
Requested by
etc...
tblTrail: Fields
ActionNo(Primary Key)
HelpNo(Foreign Key linked to HelpNo in tblHelpRequest)
RequestDate
Requested by
etc...
The objective you are trying to reach is usually achieved via the use of a subform whose recordsource is set to a query based on tblTrail which references the HelpNo field in a textbox,listbox or other control. This is referenced in the following format as the criteria:
Forms!FormName!ControlName
To ensure the new records always reference the right complaint:
Set the default value in the HelpNo field in the subform control to reference the HelpNo field in the main form. Lock & disable the control and you can set which HelpRequest the new record references.
Hope that helps a little..
Ian
[This message has been edited by Fornatian (edited 09-16-2001).]
Because there are numerous 'helpers' for each help request it is necessary to split away the 'helper action' from the 'help request' itself by storing the data in a separate table.
The structure you need is two-table like so:
tblHelpRequest: Fields
HelpNo(Primary Key)
RequestDate
Requested by
etc...
tblTrail: Fields
ActionNo(Primary Key)
HelpNo(Foreign Key linked to HelpNo in tblHelpRequest)
RequestDate
Requested by
etc...
The objective you are trying to reach is usually achieved via the use of a subform whose recordsource is set to a query based on tblTrail which references the HelpNo field in a textbox,listbox or other control. This is referenced in the following format as the criteria:
Forms!FormName!ControlName
To ensure the new records always reference the right complaint:
Set the default value in the HelpNo field in the subform control to reference the HelpNo field in the main form. Lock & disable the control and you can set which HelpRequest the new record references.
Hope that helps a little..
Ian
[This message has been edited by Fornatian (edited 09-16-2001).]
