subform

[tweetyng]

hi
i have a main form linked with subform, in the subform I would like to show all 27 records, how can I do it? please help?

Example:

Main form:

CustomerID (auto-number) : 12545

Subform: (link with customer ID) (continuous form)

Violations Score CustomerID
1 5 12545
12 4 12545

If you enter each violation # (from 1 to 27), each viloation # is one record, then it's working fine, but you have to enter 27 times. So I would like to insert all 27 violation # (27 records) when you just enter violation #1 in the form or any other easy way to do. Is it impossible to insert like this? Please help
Thanks




TN (USA). I'm using Windows XP, Crystal Reports 11 and SQL Server

 

[dhookom]

This is way confusing since this is a Report forum and your subject is subform and I think your question is actually related to tables design or queries. Also, your last line suggests your are using CR and SQL Server.

If this is actually an Access Reports question, please provide clearer information.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[tweetyng]

Thanks dhookom, I posted in the wrong forum. Thanks for reminding me.

TN (USA). I'm using Windows XP, Crystal Reports 11 and SQL Server