Solved

Multiple field values in the same form

Posted on 2006-11-29
7
263 Views
Last Modified: 2010-04-27
I have a "Work Shifts" table layout which is related to and accessed from my "Customer" table layout, casuing the customer name and ID number fields to be automatically populated by means of a script and a lookup. I must then select up to three contractors who will work on this shift in the Contractors fields, which are drop down boxes from a Contractors value list. My problem is updating the ContactorsID fields with up to three individual ID numbers. The aim is to also show the shift details in a portal on the "Contactors" layout via a ContractorsID reltionship between the "Contractors" and "Work Shifts" tables. In this way I can see a summary of what shifts each contractor works in the "Contractors" layout.

Obviously if I have three differet contractors I need three different ContractorID values on the same form, but if I have three diferent ContractorID fields (ContractorID1, ContractorID2 etc) then how can I make the relationship between the "Work Shifts" and the "Contractors" Tables?

Any help is much appreciated. I am reasonably new to all this and not at all versed in SQL, so I a hoping for a script based solution and an explanation that asummed beginner status.

Many thanks!

Tony

 
0
Comment
Question by:afbaer
  • 4
  • 2
7 Comments
 
LVL 28

Expert Comment

by:lesouef
ID: 18043789
you need a 3rd table, let's call it contractor_shifts.
it can only contain the contractor_ID and the shiftID.
everytime you schedule a contractor for a given shift, you should create a new record in this table.
this way you can view contractors for a given shift, and/or the shifts for a given contractor from within their respective layouts.
more help if you show me your file.
0
 

Author Comment

by:afbaer
ID: 18050146
Thanks, lesouef but I still don't quite get it. Showing you my table is a great idea but how do I do this?
0
 
LVL 28

Expert Comment

by:lesouef
ID: 18050306
can you post it on a web or ftp site?
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:afbaer
ID: 18051870
OK, you can get it at http://www.box.net/public/bufhm3bbcl. Go to "Cutomers" Layout and select "Shifts" . Select "+" button bottom right of screen to add a shift. The customer name and ID are automatically added. Now I need to be able to select two comperes to work this shift and have their individual ID numbers automatically appear. In this way their shift also appears in the "Comperes" layout "Shifts" portal.
Thanks!
0
 
LVL 9

Accepted Solution

by:
jvaldes earned 250 total points
ID: 18052377
In order to get a reference to work you need to add two copies of the comperes table one named "comperes 1" and the other named "comperes 2" . do this by going to the relationship screen selecting the comperes table then clicking the duplicate table button on the bottom left and typing the correct table name as above.

Now create a relationship between the shifts table and comperes table by linking the compere1 field to the fullname on the comperes 1 table and repeating the same for the comperes2 field in shifts and the fullname field in the comperes 2 table. Now that you have two different references into the comperes table go to the shifts layout and change the current top comperesID field for the one in the comperes 1 table and the lower comperesID field for the one in the table comperes 2 and like magis you should have the problem solved.

That also created two entries in the shifts portal.

I made changes in  your file and left it at http://homepage.mac.com/beckyv/

Let me know if you need any more help
0
 
LVL 28

Expert Comment

by:lesouef
ID: 18052500
I thought I had understood yr problem, but I am just confused now that I saw your file, and even more with the example of jvaldes! or I am stupid, either...
First your file does not match the pb: what is a compere? the contractor?
then what do you need gamesshifts for?

jvaldes, how would you handle a 3rd, a 4th compere?
0
 
LVL 28

Expert Comment

by:lesouef
ID: 18054157
See my mod of your file for a solution with a 3rd table to be able to cope with any amount of comperes.
The only non smart thing is the way to get the shifts compere_list updated in the shift. Actually this could be automatic if you'd use an event plug-in to update the list everytime a field is altered. So far, use th update button underneath the compere list in the shift layout
http://www.carina-tm.com/upload/Wild0.fp7
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
FM - Formatting Merge Fields 4 549
FM - Converting Fields to Records? 6 158
sending mail from filemaker pro 10 5 45
Airport Extreme 802.11ac 15 76
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now