Search results

Thanks Dave. My advise would still stand would it not. One Field for all parents just add a descriptor Field as Mother, Father etc.

You can't have the one field as Primary part of the time. It is either Primary or it is not. Suggest that this field not be used as the Primary. I am sure you have some good reasons behind this. Could you please explain where you are wanting to go and why. If you can't find a different field...

I believe you need a table for tblChildren. This table has a field linked to a second table tblParents. This is a simple one to many relationship. You can have one or more parents. Perhaps you are looking for something more advanced but this is what I believe you need based upon the...

Question. Do you need both. If the Control is not enabled then is it not locked. If the Control is enabled then is it not unlocked.

Suggest you fix it NOW. Don't wait for a possible problem along the way.

Good luck with the project and don't forget we are still here to help.

You are using a lot of this but this is the full story.

http://access.mvps.org/access/lookupfields.htm This is an explanation of where not to use lookups. This can be misunderstood. Some people think all lookups. In fact it is saying do not use lookups in Tables.

This Database may help you to understand Combo Boxes and Relationships.

The main table has One Record while the sub table has many Records. These are joined by the Primary Key (One of in the Main Table) to the Foreign Key in the Sub table. This can be many records. eg The One table has a Location of say "Building 14". The Sub has many records of what is located...

Try UPDATE before MOVENEXT. Untested.

I hope you are better at the song and dance than you are about your knowledge of the words "Database" and "Proper" You may need it one day to earn a livelihood. Do you think you could make a video of your song and dance for us to see. Seriously can you list what you feel is a proper...

Does this work on Sub Forms?

I don't like your structure at all. You have One table that is doing all the work. It simply has some lookups to make data entry simple. Ignore the lookup and complete the field manually and you end up with one very large Table. You may as well use excel. Go back and look at the table. You...

Is TYPE part of your recordset? If not it should be.

Others may wish to comment with their point of view. My suggestion is to have MySQL as your Back End. One set of tables means less possibility of mistakes. As I said this is my opinion and that you should seek other's.

Shame you did not say this in the beginning. Is there any other things we need to know. Perhaps you could start by saying why you want to maintain two tables instead of just the one like other people do.

If these Tables are in the Body of a Form, then you could use the Command "Move Replace".

Are your forms BOUND to the tables or no. If you are not using Bound forms then you will need code to save. If they are bound then the tables are updated automatically. NO code required.

Open the Table in datasheet view. Adjust the column width. Before doing anything else save the table using File, Save. Or you can use Ctrl S ------------------------------------------------- Curious as to why you want this. I hope it is not for the benefit of the user. Users should...