S
Slez via AccessMonster.com
I'm posting this with this question in mind: Is what I'm trying to do even
possible?
(I know that may drive some programmers nuts, but I have to start there!)
I have the following table structure:
tblProject has fields ProjectID & ProjectName (One side of One-to-Many
relationships)
tblBid has fields BidNumber, BidType, Estimator, etc. (on "many" side of
relationship with tblProject)
tblProjectClient has fields GCName & GCContact (also on "many" side of
relationship with tblProject)
So both tblBid & tblProjectClient are on the same "level" of relationship
with tblProject.
Ultimately, I want to create a report that, under each Project, shows the
list of BidNumber and GCName records, but because these are on that same
"level", I'm in a situation where I have to list one or the other. The query
that my report is based on returns a GCName for each BidNumber so it looks
something like this:
BidNumber 1 GCName A
BidNumber 1 GCName B
BidNumber 1 GCName C
BidNumber 2 GCName A
BidNumber 2 GCName B
BidNumber 2 GCName C
BidNumber 3 GCName A
BidNumber 3 GCName B
BidNumber 3 GCName C
...and so on...
Ideally, I'd like to convert the records in GCName into a string or something
and list them in the ProjectName Header.
I hope this make sense. Are there any suggestions out there on if this is
possible or how I can accomplish this?
Any feedback is appreciated!
Slez
possible?
(I know that may drive some programmers nuts, but I have to start there!)
I have the following table structure:
tblProject has fields ProjectID & ProjectName (One side of One-to-Many
relationships)
tblBid has fields BidNumber, BidType, Estimator, etc. (on "many" side of
relationship with tblProject)
tblProjectClient has fields GCName & GCContact (also on "many" side of
relationship with tblProject)
So both tblBid & tblProjectClient are on the same "level" of relationship
with tblProject.
Ultimately, I want to create a report that, under each Project, shows the
list of BidNumber and GCName records, but because these are on that same
"level", I'm in a situation where I have to list one or the other. The query
that my report is based on returns a GCName for each BidNumber so it looks
something like this:
BidNumber 1 GCName A
BidNumber 1 GCName B
BidNumber 1 GCName C
BidNumber 2 GCName A
BidNumber 2 GCName B
BidNumber 2 GCName C
BidNumber 3 GCName A
BidNumber 3 GCName B
BidNumber 3 GCName C
...and so on...
Ideally, I'd like to convert the records in GCName into a string or something
and list them in the ProjectName Header.
I hope this make sense. Are there any suggestions out there on if this is
possible or how I can accomplish this?
Any feedback is appreciated!
Slez