Report with a non-predifined number of sub-records

[manticore01]

Erm I'l try my best to explain what im trying to do. I have reasonable experience with Access but not so much with VBA so i suppose in that sence im a n00b.

Basically I am trying to create a database that has details of a client in. But this client will have a non-predifined number of credits and past work experience.

Therefore some clients will have say 5 previous roles ina film and another only has 2.

I therefore created one table which will hold just the details of the previous roles. The ID field links via a lookup to the main ClientID table.

I am trying to work out the best way to end up with a report that will have the clients details (All contained within the ClientID table) and then the list of previous roles (Client_Credits). I tried doing this with a subreport but i have to end up putting in the name for the client twice when viewing the report (Enter Parameter Name box appears twice).

How do you think i shoudl best do this.

Ideally i want to able to view the Clients CV (Made in a report) by entering the clients name. The report would then list everything that was needed.

I presume ill need to make some sort of query but not sure how to make all the clients credits contained within one Cleint report.

I hope someone can make sence of this.

Thanks very much in advance

Chris

 

[Leopardfist]

I'm not a pro, but have you set up the relationship for the two tables? I think once you do the relationship, you should only have to enter the parameter once.

 

[manticore01]

Hi yes all the relationships were set up correctly, i managed to find a work around.

It worked if i put in a subform rather then a subreport, i know this is stupid really but yeah, it works now with the Subform, so ive just formatted my form to look like a report!!

Thanks for you feedback though

Chris

 

[Leopardfist]

It may be easier to create a single query on both tables, then to create your report on the query, that way you wouldn't need a subreport or subform, you would have all the data you need in your query.

 

[manticore01]

the problem with that is then i get more then one report per client in order to allow for the multiple credits per client. I did try that