How can I create this?

[fokalfokal]

Hi everyone,

I want to design suppliers id and its inventory list shown as above. when i click desired supplier i want to see its inventory info. my two lists have already been ready but i couldn't combine them that i want...

i prefer table view for two lists.

if you are assistance to me, i' ll be very happy...

[aldipalo]

What is your relationship between the two tables?

You need to set this up in order to sync data from one table to another.

On the other hand you can not develop a table layout that would look like the diagram shown.

[fokalfokal]

first list includes suppliers' name, phone number and fax number. Second list consists of inventory info of our suppliers such as product name, inventory quantity etc.

what is the best design similar to that i would like to create?

please be assistance to me...

[efen]

You can create something similar using two portals -- see attached files.

You could also make the line joining the two portals a conditional calculation line/container field instead of just the simple drawn line

suppliers.zip

[fokalfokal]

thanks for helping me...efen