over my head

[Jason]

I have a bit of a design delemia. I am hoping someone can help me before I
stray too far down the wrong path. All tables are in a backend file. I have a
tbl with the following.

Tbl_UnitHours
[UHID]
[ShiftAssignedto]
[Positition]*
[Unit]*
[DayofWeek]*
[Station]*
[Starttime]
[Endtime]

*fields are link to other tables

Another table called Tbl_Shifts is a listing of the shift names. Each shift
is made up of 4 to 5 records from the Tbl_Unithours

What I would like to do is have a form that I use to build shifts. That form
would be based on Tbl_Shifts. Then have a sub form that I can pick from the
tbl_Unithours. When I pick a record from that table it would drop in the
ShiftID number into the [Shiftassignedto] field.

I cannot seem to get my mind around this how to do this. What would be ideal
is to have my records from the tbl_unithours come to my form through a qry
that would only return the records where the [shiftassigned] to field is
null. That way my list gets shorter as I build the shifts.

I hope this makes some kind of sense.

Thank you

 

[mscertified]

You have not explained the requirements very clearly. Why do you have 'shift
assigned to' in your Tbl_UnitHours when you say a shift is made up of
multiple records from this table? Seems like to need a Shift table to contain
that. Or can a shift be assigned to multiple people?
Give us the layout of ALL your tables, it might help.

-Dorian

 

[Jason]

My employee records will have a field that contains their shift number. Each
shift is made up of four to five records from the UnitHour table. Before I
can assign the shift to the employee I need to build the shifts.

 

[Peter Yang[MSFT]]

Hello Jason,

I think you may want to use 2 subforms for the Tbl_UnitHours. One subform
is all the records in Tbl_UnitHours that ShiftAssignedto is null. The other
subform is the records have Shiftassignedto equals to ShiftID in the parent
form record.

You could use 2 button to add/remove items from/to above 2 subforms. If a
record is remomved from one subform, it is added to the other one.

If you have any further comments, please feel free to let's know. Thank
you.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Peter Yang[MSFT]]

Hi Jason,

I'm still interested in this issue. If you have any comments or questions,
please feel free to let's know. We look forward to hearing from you.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

======================================================

This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================