I have 3 tables, one is user information including basic information
such us name, last name, phone, fax, cell etc. Second one is systems
including serial number of the system (it is text, not number-includes
letters). Third database includes parts. After database was created, I
have inserted data from excel. It was OK. Then I decided to create
another part within systems table. I inserted field serial number and
model. This information I took form third table - parts. I create
relationship with serial number and lookup with model. It worked
perfectly. However, I realized, portal will be much easier and precise.
Then, I created ID field in table systems and table parts. ID is defined
as number.
I created another relationship connecting ID fields. I went back to
systems table, entered layout mode and create portal, select parts table
as reference table (where information will be taken from) and then
choose only two fields to be inserted in portal. This are SN and part
description. I went back to browse mode and gave to one system unique ID
number 5. I switch to part table and gave same ID number 5 to three
selected parts. As a result, I do not see relevant information in portal.

Then I created test database with two tables. One has personal
information such as name last name and some unique number (called ID)
and second one has some items such as fruit>apple or vegetable>tomato.
To each record in second table I gave ID. After filling records in both
database I switched to layout mode and in table with personal records
created portal. Of course, tables were conncted in relationship with
ID's. After switching to browse mode, information in portal are there.

What went wrong in my original database?