How to Use IF formula in Forms to retrieve Data from another table

[Kiran Prakash]

Is it possible to retrieve data by using IF formula, if the data required is present in some other table which is already entered



eg A is table 1 B is table 2 C is Table


Is it possible we enter data in Table A data that is equal to "Some Value " then certain data from Table B and Table C should be displayed in the current form

[June7]

If tables don't have relationship and can't be directly joined in query, use domain aggregate functions.

Or use multi-column comboboxes.

Really not enough information.

[Kiran Prakash]

How to make the if Common formula in Form and data will take from Table.

[orange]

Please tell readers what you are trying to achieve with some sample data and tables. It would also be helpful to readers and you if you could describe the "application and main processes" of the business this proposed database will support. Use simple, plain English for the description to ensure readers understand your situation/issue.

It is important to get your tables and relationships identified, designed and tested with sample data before getting too deeply into physical database. Tables and relationships are critical to a useful, maintainable database.

Good luck with your project.