access United States
  • 13 years ago

    Dear All,

    I'm currently working on a database and want to be able to get different subdatasheets depending upon a specific entry entered in the table above.

    I can get simple subdatasheets working fine but want them to be specific to one of 4 different entries

    Currently the database relationships go

    Table 1 to Table 2 = one to many
    Table 2 to 4 different Table 3's = one to many

    However I can only get Table 2 to go into 1 table 3, rather than being specific and being able to use all 4 depending on what value is entered in one data field.

    Is it possible that different subdatasheets can be used that are specific to previous data entry?

    Sorry if it is not 100% clear but is very hard to explain!

    Any suggestions / ideas / help are welcomed!

    Many thanks, Steve

Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).


Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“UNIX is basically a simple operating system, but you have to be a genius to understand the simplicity.” - Dennis Ritchie