Problem in Query

[Bruno Trindade]

Hi,

I created one query, but when I change the data for one row, the others rows with same data that I change, change too.

For example, I have two columns Name and Mobile number.

Name Mobile
Bruno Trindade 123456789
Bruno Trindade 548645485

If I change Bruno Trindade in first row to another name, the name in second row change too.

Can you help me with this?

Regards.

 

[DanWall]

Instead of referring to the NAME in the expression, refer to the Indexed ID of the person.

An indexed ID only allows unique values.

 

[Bruno Trindade]

Instead of referring to the NAME in the expression, refer to the Indexed ID of the person.

An indexed ID only allows unique values.

But I need to permit more than one value.

The problem is

I've several table, I build one query using this SQL:

SELECT Utilizadores.Utilizador, Utilizadores.Local, Equipamentos.Marca, Equipamentos.Modelo, Equipamentos.IMEI, Cartoes.N_Cartao, Equipamentos.Data, Packs.Tarifario & '_' & Packs.Numero AS Tarifario_Final, EstDistCont.Distrito
FROM (Utilizadores LEFT JOIN EstDistCont ON Utilizadores.Local = EstDistCont.ID) LEFT JOIN ((Equipamentos LEFT JOIN Cartoes ON Equipamentos.ID = Cartoes.ID_Equipamento) LEFT JOIN Packs ON Cartoes.ID_Tarifario = Packs.ID) ON Utilizadores.ID = Equipamentos.ID_Utilizador;

After this I created one form based on this query and in the form I've two rows where Utilizador is Bruno Trindade, because I have two mobile numbers. If I change the first row, where appears Bruno Trindade, to another utilizador(user) for example John, the second row replace Bruno Trindade to John too, but I only want to change the first row.

 

[DanWall]

You can still have multiple values in the NAME column, however you need to reference a UNIQUE identity for each row.

Right now, you are refering to the NAME.

You need to add another column, that has a unique ID, that isolates that row from all the others.