Data in form

[FilasLam]

Hi

First of all your relationships between tables is wrong.

You have tables named :-

Exceptions
Overview
Jersey Number
Sheet

Can you explain in simple English what your business process is?

The purpose of this database is to fill in new contracts, look up existing contracts and change those. The problem I have only requires table 'overview'. The other tables are used for something different. The problem now is that is can't get the form to show me the data that is in the table overview. When that is solved, then the database will be good for use. Is there anyway to solve this?

 

[FilasLam]

My problem doesn't have to do with the relations between the tables. My problem has to do with the form not showing the data from 1 table, table 'overview'. I want the form to show me the data that I search for with either 'abonnementsnummer', 'company', 'abonnementsnummer nieuw' or 'beheerder'. so when I look up one, that all the other fields are filled in automatically.

 

[mike60smart]

My problem doesn't have to do with the relations between the tables. My problem has to do with the form not showing the data from 1 table, table 'overview'. I want the form to show me the data that I search for with either 'abonnementsnummer', 'company', 'abonnementsnummer nieuw' or 'beheerder'. so when I look up one, that all the other fields are filled in automatically.

The only way to do what you need is to have an Unbound Textbox in the header with some VBA to allow you to find the data selected.

I was not able to find a field named "abonnementsnummer nieuw" in your Form?

See the example attached.

You do however need to sort out relationships.

 

[Cotswold]

As I understand it your choices are :
If the form is directly linked to a Query or Table and you edit a field on the form, then tab to another form field, move to a button, or other object, then the change in that field has been saved back to the table.

If you loaded an unbound form with the contents of a record transferred to each of the Form!Fields, then you decide if, or when the changed data is saved back to the Table.

I would reiterate the advice of Arnelgp on post #14 as the main priority.