Limiting entries

[dmogie]

Hello, I need help. I have two tables.

horse_entries
ent_HorseName (PK)
ent_entries

horse_information
inf_HorseName (PK)
inf_Ground
inf_Notes

It is a many-to-many relationship. When I open a table and enter a record there is a small + sign that allows me to open up the rows from the other table to enter directly into it. Can this be turned off? Also I can enter more than one record through this way. I only want one entry in inf_Ground, inf_Notes and inf_Entries for each HorseName. How would I do this? As you can tell I am completely new to Access and trying to learn. Thanks

 

[Dennisk]

If you go into the design of each table there is a sub table property that you can disable.

However in general I cannot see how your two tables fit into a Many to Many scheme as you would require as the minimum two foreign keys.

Also to quote a maxim ' tables are for storing data, forms are for entering data'.

 

[dmogie]

If you go into the design of each table there is a sub table property that you can disable.

Thanks, worked great

However in general I cannot see how your two tables fit into a Many to Many scheme as you would require as the minimum two foreign keys.

I am wrong, it's a one-to-one relationship. I have enforce referential integrity turned off.

Also to quote a maxim ' tables are for storing data, forms are for entering data'.

The problem is I have a lot of data all in .txt files I have to get in my table. Is this possible using forms?

I have tried importing them but I need an entry to be placed in 'ent_entries' for each horse. It takes a long time putting it in one by one. Is this possible using forms? For example say I have a list horses, and I want to add JH1 into 'ent_entries' as well as their name into 'ent_HorseName (PK)'. How would I do this?

Thanks for helping me