I have the following problem. I'm working on a solution for the owner of several restaurants. Each restaurant has meetings once or twice a month. How would I structure the tables so that I could have a layout on which I select a restaurant and then inside a portal I get a list of all employees. On the portal for each row I want to have a button or checkbox to mark if an employee is present or not.
I already have the following tables:
Restaurants, Employees and Meetings
So far I have a relationship between the Restaurants and Employees table which I use to assign employees to a restaurant, and a relationship between the Meeting and Restaurant table, which allows me to show all employees that work at a selected restaurant using a portal on the meetings layout. How do I proceed to solve my problem? Do I create another table MeetingAttendees or something similar that I use to keep track of people attending a meeting? How would I create a relationship then to allow me to mark certain employees as present and absent?
Thanks in advance,
I have just downloaded the 360works Email plugin Sample and I am doing some tests to check whether this would solve my problem. I would like to be able to download all emails from my email account into "messages" table and then on each customer record show those emails which are related to that customer via a portal based on a relationship between, but what I can not figure out how to do it is that the portal would show but types of emails those marked as "from" emails and those marketd as "to" emails. So far I have created a relationship between Customers::email ------- Messages::From and the portal would show all "from" messages. If I would set the relationship as Customers:email ------ Messages:To, the portal shows all "to" messages, but what I am trying to make is a join portal that would show by date both "from" and "to" messages, then I plan to make a Conditional Formating saying that if Customers:email = Messages::From then all text in blue, and all text in green when it is TO.
Is this something that can be achieved?
Thanks a lot for any tip,
I guess people are using a similar technique for creating and editing portal records after the new FM16 card window feature, any posts or links about this?
In any case, this is how I'm doing it (sample attached) ... any feedback appreciated!
Create or edit portal records.fmp12
So i'm dealing with two tables.
in a VisitTable layout, i have one or two portals related to the GraphicsTable, each related by a different factor. One portal would be related by a Date field, the other would be a ClientName field..
My desire is to click on a thumbnail in either one of these portals, and have that selected image be displayed in a separate/larger image window (which could be a container field in the current table, Or another portal? I don't care how - i just need to have it show up)
I don't know the best method for doing this (ie., click thumbnail to have image fillin a separate location). In this particular instance, I don't want this to be a separate window, but to display in a container field view on the current window/layout.
how do I accomplish this?
Table 1 (Visits) is a clinic visit table, with numerous fields of data.
Table 2 (Prescriptions) is a related table for prescriptions given on a particular visit. Table2 is related to Table1 by fkey - - - T1ID.
Table 3 (Patient) is a patient table (contacts). PatientID is the identifier for Patient and is related in Visits,Prescriptions, and Patient
I need to have (in a Visits layout) a portal (self-related by PatientID), which shows a list of previous visits to the clinic by this patient.
On this portal I need to show any (1 or many) Prescriptions (from Prescriptions table) which would've been given during that particular Visit
So it's in essence a need to show 2 foreign tables (1 being a self-view by PatientID and the other being the Prescriptions but filtered by PatientID
I have been unable to figure out a good method for this.
My only thought has been to give up on working *IN* Visits, but creating a separate table ("Combiner"), and in Combiner, hold all Visits and Prescription data.
Could I also have a Combiner table that's simply an active "calculation" table, where these two tables are 'looked up' on an as-needed basis, combined, and fed into Visits via a portal? (so it's not actually held data, but is looked up as needed)
what's the preferred method?