Table relationship and deconcatenation

[thibs27]

Hi,
I am try to relate 2 tables by deconcatening a field from the first 1
for example, I have a table named alimentation and 1 other that is the details. The details has 3 fields and i would like the alimentation table to relate to all fields of the other table.
For example, i would have the field "120V, 12Vcc, 129Vcc" related to the three fields in the table details, 120V for the first field, and etc.

how could i deconcatenate the field

Thank You
And sry for the bad english

 

[thibs27]

My bad

I have three tables for the details but anyway
Is there a way to have those three tables related to the table alimentation ?
And to have the same thing has the upper post?
Thank You

 

[dkinley]

So what are you wanting as a result? Are you wanting to strip off the alpha-characters and leave the numeric?

Are you wanting to establish primary keys and foreign keys for the tables so this doesn't happen again, and you won't have to use these fields but let Access do it's job and perform this for you?

-dK

 

[thibs27]

I want that when I enter let's say
120V, 129Vcc, 12Vcc
I want that my combo box let's me choose
in 1st table, things related to 120V
in 2nd table, things related to 129Vcc
in 3rd table, things related to 12Vcc

Thank you

 

[dkinley]

So, let's say you have a form. On that form is a combo box and a subform. The combo box would have the option of choosing some voltage specification and the results be presented in a subform?

This can be done a per table basis as you just requested but I am confused on your original post trying to relate these tables together based on this .... ?

-dK

 

[thibs27]

I just want to be able to choose the type of voltage for 3 different fields based on just 1 that would contain all 3 types, but separated by comas.
The linking was about linking those three tables to the other one

Thank you

 

[dkinley]

So you have:
- 3 tables and you want to search all of the tables at the same time.
- Each table has a field (the one you want to search on). That field could have 1 of 4 possible combinations:
-- 120V
-- 129Vcc
-- 12Vcc
-- 120V, 129Vcc, 12Vcc
- The tables can be linked together by ..... how?

-dK

 

[thibs27]

It's OK i found another way
Thanks anyway