ok, I am full of problems, anyway...

Lets say i have 2 tables: Shows and Venues.

Shows consists of:
show ID
date
venue ID

Venues consistes of:
venue ID
Venue name
location

I can list the shows, but how do i link it so that I can also show the other info in the venue table like this


Show Date - Venue name - Location


I want to beable to use both tables in a repeated table.

I hope this makes sense.

Thanks
Joe



Edited by - jhm4021 on 31 Jan 2002 08:43:38

What DB are you using?
If it's Access, first create relationship between those two tables and then create a query with fields from them. After that, instead of using tables, use query to display data on page.
SQL Server works the same way except that relationships are diagrams and queries are views.

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
ok, I am full of problems, anyway...

Lets say i have 2 tables: Shows and Venues.

Shows consists of:
show ID
date
venue ID

Venues consistes of:
venue ID
Venue name
location

I can list the shows, but how do i link it so that I can also show the other info in the venue table like this


Show Date - Venue name - Location


I want to beable to use both tables in a repeated table.

I hope this makes sense.

Thanks
Joe



Edited by - jhm4021 on 31 Jan 2002 08:43:38
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Viktor Farcic

TalkZone Manager