Simple Portal needed

[JD2775]

Hi guys,

I need to create a layout that when one field is populated with a value, the other values populate automatically based off of the value. The process is the user will front load data via Excel, with about 10 columns of data. One of the fields is "SIID". What I want is a layout that has all the field boxes blank, and when the user enters a specific SIID the rest of the fields populate with the related data. I am guessing a portal is the way to go here, but currently I only have one table. How should I work this? Thanks

[Vaughan]

First of all I'd import all the Excel data into a table in FMP, with the SIID field unique so that duplicates cannot be created. Create a relationship between this table and the other one based on the SIID field.

In the other table, select the SIID field and display the related fields, or use auto-enters or lookups to copy the data into the other table.

A portal is only needed to display multiple related records.

[JD2775]

Thanks Vaughan. What is the "other table" though? This data (6 fields) will be imported into a single table. What fields should be in the other table? The SIID would be a unique 9 digit number, so no problems there.

Also, I should probably add...

In this layout after a SIID is populated, 5 other fields would populate automatically but I would also have a 6th field, a date/timestamp field that would need to be entered at that time. The rest of the data (Fields 1-5) are just for visual verification but are not to be edited, or the records altered in any way. Only the 6th field would get data put into it (which obviously has no data in it, until manually entering a date/timestamp)

Hope that makes sense.

SIID entered

Field1-Field5 (related data pops up, can not be edited)

Field6 (date/time field entered at that time)

EDIT***** Nevermind I figured it out, I wasnt thinking about this clearly. Table1 would have all the uploaded data which wouldnt be touched, Table2 would have 6 fields of data, (1 SIID, 4 lookup fields based off SIID, and 1` Date field). Then when I want to combine all the data together I would have a report of Table1 with an additional ::Date/Time field from Table2 brought in. Got it

[Vaughan]

Glad you worked it out...