Re: how: 3 blocks (1:many:many) using only 1 database source

From: Matthias Kleinicke <Matthias.Kleinicke_at_gmx.de>
Date: Thu, 11 Aug 2005 23:45:49 +0200
Message-ID: <ddgge0$429$1@online.de>

Hi gnober,

gnober schrieb:
> Now, if i were to use 3 different tables for each block then it would
> be no problem as i would just relate them in forms.. How do i do this
> if i were to use only a single table for each blocks as i don�t think
> i could just relate them normally?

there are two possible situations:
1. All blocks contain different rows of the same table: this case You should relate the block normally. 2. The rows inside some blocks are shared: here You must solve the situation, because You can not update the same row in two different blocks.

according to your post at least one modified row is contained in two blocks. else there should be no update contention.

best solution in this case seems to create one db-block and two non db-blocks. populating and updating of the non db-blocks is done via copy to the db-block.

anyway there would be a lot of coding to do.

greetings

Matthias Received on Thu Aug 11 2005 - 16:45:49 CDT