Portal for lookups

[Amram Chayim Eirinberg]

I have fields in table 1 that is set to auto lookup from fields from a related table2.

Any given record in table 1 can be related to several records in table 2

I want to get all the related records from table 2 in a portal in table1 but in table1-native lookup fields, how do I go about doing this?

Any help will be very much appreciated!

Amram Chayim Eirinberg

[efen]

I'm not sure that I understand what you want here.

Because they are related the records will already show in a portal? Or do you mean that you want the information in some of the related record fields to be incorporated into table 1? If so, what is the point of that? or have I misunderstood this completely?

[bruceR]

I agree, what's the point?

Sounds like Amram is trying to create many-fields-same-type, like Phone01, Phone02, Phone03 which is unnormalized and a bad idea.