Ok i need some help, maybe i set up my database structure wrong <img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle>

here goes,,

Site Table
SiteID
Site

Members Table
ID
MemberID
Name
Site (which gets inserted from Sites in the)
Access (gets inserted from Access table with multiple access types)

--
I need to Create a query to view all records from member list in the format :

Site 1 | Site 2 | Site 3 | Site 4
Nick Access | Access | Access | Access

tried sevral things <img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle>
nothing seems to work
maybe i can do this with a query ?
if anyone can help <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>
thanx






Edited by - Disorder on 07/30/2001 00:37:03

Well this is a bit difficult to explain - and I don't really have time to write a tutorial about it ... but I will try to explain.

You can do this only with two separate Recordsets and two repeat regions.

The first Recordset is rsUsers - just displaying a user list.
The second one is rsSites - this one should display the site PER USER! This means that you have to filter this recordset INSIDE the repeated region where you display the users.

---------------------------------------
George Petrov - CTO, www.UDzone.com

www.UDzone.com : A Dreamweaver,
Dreamweaver Ultradev and Fireworks site
by developers for developers.
---------------------------------------

:mmm still confused:thanx

I'm not sure if this will work with your DB, it works under MySQL so it might work, or it could need some tweaking. Create a recordset, name it, and then go to advanced and try :-

SELECT Members.Name AS Nick, Members.Access AS SiteAccess, Site.Site AS SiteName
FROM Members,Site
WHERE Members.Site=Site.SiteID

Tim Green

Extension & PHP TalkZone Manager

------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
------------------------------------------

Thanx , that dint work either it just gives me a list of names

I want to present the data in the format :
| SITE | SITE | SITE | etc etc
NICK | Access| Access|Access| etc
Another Nick | Access| Access|Access| etc

ane ideaS? :the way i see it i need to run 2 rs's ? and nested repeats ?