I don't really have a problem but I'm trying to understand some logic behind logical tables.

I had an existing Logical table set up as follows:

Logical Company 502
Specified Table tcmcs034 Price Lists -> Physical company 503

I then introduced another Logical table setting:

Logical Company 503
Specified Table tcmcs034 Price Lists -> Physical company 501

I tested the setting by adding a record to the tcmcs034 table via Maintain Price Lists in company 501. I then went into company 503 expecting to see the change. The new price list record could not be seen. The same happened if I added a record from 503, it did not show in 501. If I did the same operation in 502/503 the logical link was in place and you could see any new records added across both companies.

To resolve this issue in 501/503 I removed the record:- logical company 502 ->tcmcs034->Physical Company 503. Why should this make any difference?



Could somebody explain the logic as to why a logical table will not work if you have another logical relation in place with the same table?

Thanks

PJ

We are having 4 Baan companies in production 001, 002, 003 and 004. 001 is treated as physical company and 002,003 and 004 are treated as logical companies for maintaining Baan master data tables. Whenever we maintain data in any logical company we can able to see data across all companies. We never used to enter data from physical company as we are not having access to it. So I am not sure whether we can access data across all logical companies if entered from Physical company. Have you got any logic from the above? I think a company cannot be logical and physical at a time.

PJ,

I think your problem is that you are defining the same table from the one company as both logical and physical at the same time. I don't think Baan can handle this. Regarding inserts, it should not make a difference whether you do it from the logical or physical company as they both will perform the action on the one database table.

I agree with Patrick.

Company 502 uses Ttcmcs034503.

Then you tell company 503 to use Ttcmcs034501.

503 is already, by default using tcmcs034503.

I don't think you can tell baan to use a logical table rather than its real physical one - Can you?

Hello there,

the answer to all this is simple:

Baan does not support double indirection in logigal tables.

A logical table must always be linked to a physical one. You can not link a logical table to another logical tables, nor is this ever needed.

Example:
Let's say you have three companies 100, 200 and 300.

100 is supposed to be logical to 200 and 200 is supposed to be logical to 300. 300 is the physical company. Baan does not support this directly! But you might as well make 100 logical to 300 and 200 logical to 300. The result is exactly the same and works in baan!

Regards

Markus

Thanks for your replies.

I knew that there must have been a good reason but just couldn't put my finger on it.

Cheers

PJ

If you check compnr6.[12] you can see the explanation: I suppose the file is simply read sequential and there is no processing being done.

Han