Delete Unexistant field

[fgcity]

Hi all.

I have the following problem:

I have 2 tables:

On table A i have a text in a field "CVB45"

On Table B i don't have that text in a field (i have some other text "FGH56")

How can i automatically delete the Field from Table B if it doesn't exist in Table A ?

The problem is that the Keys are not the same in 2 Tables. In Table A i have the ID from 0 - 60 (this is always static)

And in table B i have automatically generated numbers that could be anything.

How do i do this? Please help out.

 

[jal]

Hi all.

I have the following problem:

I have 2 tables:

On table A i have a text in a field "CVB45"

On Table B i don't have that text in a field (i have some other text "FGH56")

How can i automatically delete the Field from Table B if it doesn't exist in Table A ?

The problem is that the Keys are not the same in 2 Tables. In Table A i have the ID from 0 - 60 (this is always static)

And in table B i have automatically generated numbers that could be anything.

How do i do this? Please help out.

Your question seems unclear - it's not clear the criteria for deletion, for example, that is, under what circumstances do you need to "automatically delete" something.

Nor is it clear the nature of the tables and the relationship between them.

 

[neileg]

I presume that you don't want to delete a field, but it's not clear if you want to delete the data in that particular field or whether you want to delete the record.

 

[fgcity]

it's OK, i found a solution.

Tnx for the reply though. I really appriciate it.

 

[boblarson]

it's OK, i found a solution.

Tnx for the reply though. I really appriciate it.

Any chance you can post your solution so others can benefit, if they are having the same issue?

 

[fgcity]

i'm still testing it, i'm not sure if it's working correctly