Newbie : Show data in List View with other data

[zamzame]

Hi.!

I'm making lists of data in a layout.

I can make a list of data in a layout but I can't figure how to make several lists on a layout.

I am making two product tables named category A and category B(each data is a product)

I want to show the whole lists (or the last 5 items) of category A and B.(in two separate list)

For example,

-Layout WholeProducts-

____________________

category A

M&Ms

Hurshys

Biggy

...

category B

Coca cola

Fanta

Nestea

...

____________________

I want to create , modify, delete items in those lists as well as to see the two lists on a same layout.

I did try to modify a 'table view' layout of <category A> to include a list of <category B>, but it just doesn't work well.(I can't create new records of B, only show the same number of products with the number of A, etc.)

I also thought about making a portal, but how can I define the relationship if there isn't any relationship between the two tables(category A and category :

-Should I make another table?

-Also I think there will be some display problem making a portal, what if the number of data exceeds portal rows?

Thank you for reading this.. Plz give me a hint-

[Oldfogey]

I think this is a design issue. Why do you need two tables? I would put all of the products in one table and use a field 'Category' to differentiate between the different categories.

[zamzame]

Well. That is a good idea. excellent actually. I didn't think about merging those tables..

But surely I can if I want to.

Actually my database is quite different from my example.(I just wanted to simplify my question)

Mine is an image database and I separated my DB into 2 parts.

Data and Image.

There are different data tables and those data should be separated into many tables.

But I added tables which keep relationship information between Data and Image.

As a result those 'connecting' tables consists of only two fields both are numbers (which is Data ID and Image ID)

For example data no.2 matches to image no.5

Then in a 'connecting' table looks like

Data ID | Image ID

2 | 5

..

and I made a 'connecting' table for each data table.

But I might make one connecting table for all data tables.

Well. Thanks for your tip really

I feel like your tip opened my eyes into a new world.

I should have considered this option.

Now I have to figure out how I can make portals to evaluate whether a relationship information is about the tables they belongs to.

[Oldfogey]

>> Now I have to figure out how I can make portals to evaluate whether a

>> relationship information is about the tables they belongs to.

Can you elaborate on that?