Subforms "multi-table"

Carlos_CosmeCarlos_Cosme Member Posts: 2
Hi,

the question is... I want to create the typical subform that allows users to choose a table name, like Product, Resource... and in the next textbox shows the related records. For example a subform that shows two attributes:

Type(Option), with the options Product and Resource

No.(Code) --> I want this to show the list of resources (if Type = Resource) or products (if Type = Product)

Somebody knows how to do it?.

Thanks :lol:

Comments

  • ArhontisArhontis Member Posts: 667
    Hello Carlos,

    Welcome to Mibuso...

    The form will be used as a lookup? or data entering?

    In either cases I suggest you make a table of your own with a few general columns, and while selection the Type (which I doubt it should be in the table) you could fill it with the data of the corresponding table. That way you can make it as a general lookup form.

    If you want the user to be able to modify the data on that form, then you should make functionality that finds the source and modifies or inserts or deletes the data on the real tables, but this is not recommended for simple demands because it is a little tricky...

    Is there a particular reason that you want that specific functionality?
Sign In or Register to comment.