in the database you have built, you need to create a relationship between two fields in two tables. field 1…
in the database you have built, you need to create a relationship between two fields in two tables. field 1 in table a has the number data type and field 1 in table b has the currency data type. will you be able to build a relationship? no
Answer
Brief Explanations:
For a relationship to be established between two fields in different tables in a database, they should have compatible data types. The Number data type and Currency data type are different. Currency data type has specific formatting and precision rules related to monetary values, while Number data type is more general - purpose for numeric values. So, a relationship cannot be created as - is.
Answer:
No