I see what you have under Truck, but don't see in your post what the problem is with the data shown. Is it in the wrong order? The wrong data? Shouldn't be visible in the second portal row?
As a side note if anyone knows how: I'd also like to be able to add portal records without an associated Invoice Id so that we can keep track of other scheduling events that may not be invoices.
Without knowing more about your tables and relationships, you might want to go ahead and generate an invoice record and invoice number for all events, but use a status field in the invoice table that identifies specific events as "non invoice" or "non-billable". (There are other approaches that may be possible, but I'd have to know more about the structure of your system before I could tell if they are even possible, let alone pracitical for your solution.)
The problem is that when I type the truck ID into the first field in the first portal row, it populates it in the second row as well (this is pictured in the "result" half of the uploaded photo.)
I thought that was the case, but wanted to be sure.
What is the relationship between your main table and this portal? You can post that with text in this format:
MainTable::KeyField = PortalTable::keyField
Also, please describe how you build your list of trucks. Is this a calculation field that uses the List function? Presumably, there's a relationship involved here that I'll need to see as well.
Showday Relationships are:
Invoices::InvoiceID = ShowdayLink::InvoiceID <--portal table
ShowdayLink::ShiowdayID = Showday::ShowdayID
Truck relationships are:
TruckShowday::ShowdayID = Showday::ShowdayID
the trucks are all text fields with make, model, ID number and type-- no lists. Each truck is its own record (we only have 8). The truckshowday link table uses lookups from the truck table. (ID and Type are the looked up fields in the linking table)
I'm assuming your layout above is based in Invoices.
I think I see the problem, but let's dig a little deeper to be sure.
- The object in the portal that lists the trucks is a repeating text field?
- In which table is it defined and how do you put the truck data from Trucks (or TruckShowDay) into the repetitions of this field?
- Is your portal based on ShowdayLink or ShowDay?
The layout I posted is based in the showday table.
^that is correct, though.
1. yes. It has 6 repeating ID fields and 6 repeating type fields that lookup the type based on the ID
2. its defined in the <TruckShowday> linking table.
3. the portal is based on <ShowdayLink>
Take a close look at that relationship. If the layout is based on ShowDay and the portal is based on ShowdayLink, then there is no direct connection between the ShowdayLink portal record and the record in TruckShowDay. Any data reference to TruckShowday traces from ShowDayLink to ShowDay to TruckShowDay. Thus any record in the portal is going to match to the same related record in TruckShowDay. It's the same as though you just put this field on the ShowDay layout outside the portal.
Each ShowdayLink matches a specific invoice to a specific "day" record in ShowDay. The only interpretation of your layout that makes sense to me is that you want a list of the trucks needed for that specific invoice. That would require a link from invoices to TruckShowday.
awesome. I was so caught up in the relationships that it didn't occur to me to think of the Invoice table as the central point.
Thanks! That worked perfectly.