Macro Window

  • Thread starter Thread starter Karan
  • Start date Start date
K

Karan

Hi,

I have a table called products and another table called Inventory
Transactions. I created relationship between them. When i open the
Products Table i will have the + sign in the first coloum. clicking on it
will show the Inventory Transaction details for that record. Now the
Problem is, I deleted the inventory Transaction table, which is not working
like i want. Now if i click on the +sign (which is still showing, and i
have deleted the relationship) I says the following message:

"The table or query name 'Inventory Transactions' you entered in either the
property sheet or macro is misspelled or refers to a table or query that
doesn't exist.
If the invalid name is in a macro, an Action Failed dialog box will display
the macro name and the macro's arguments after you click OK. Open the macro
window and enter the correct name."

This is the message ! I need another table Orders to be related with
Products. How can i do it? any help will be highly appreciated.

Thanks & have a nice day !!!

Karan
 
Karan,

Open your Products table in Design view and go to menu item View >
Properties. Locate the Subdatasheet property and change the setting to
either [Auto] or [None]. This should make the error message disappear.
Then, when you create your Orders table, if you have set the setting to
[Auto] in the previous step, it will be picket up automatically as soon as
you create a relationship between the two tables. If you have selected
[None], you can always go back and change it to whichever related table you
want or [Auto].

HTH,
Nikos
 
Back
Top