Relationship with conditions?

[KK]

Hi everyone,

I am trying to automate a monthly procedure of account summary process.

I have the e-statment from the supplier with charges to each sequence number
and my record of cost centre for these sequence number belongs to. The
problem is that my record is a range type while the statement is in single
sequece.

For example, my record is from 200 to 210 to centre 12-3456-78 while the
statemet has 200 $31.95, 201 $32 etc.

Is there a way I can have the cost centre related to singe sequence number?
Thanks.

 

[Larry Linson]

I, unfortunately, have a problem figuring out what you have and what you
want?

You ask "can I have the cost centre related to a single sequence number?" Of
course you can, if you define it that way -- however, from your description
it seems you are trying to create a model of a real-world situation where
the cost centres are NOT related to a single sequence number, so doing so
might not really be what you want to do.

The highest probability of getting a useful answer is when the question is
clear, detailed, precise, and concise.

Larry Linson
Microsoft Office Access MVP