A Multiuser Problem

Giganews Newsgroups
Subject: A Multiuser Problem
Posted by:  Patrick Finucane (patrickfinucane…@gmail.com)
Date: Tue, 24 Dec 2019

I am working on an app written by person.  And he did something that is har=
d for me to follow.  But I think I know why he did it.

There is a Contacts table.  The records are displayed in a continuous form.=
  The record source is a query.  It links the Contacts table to a secondary=
table.  The secondary table has 2 fields, the foreign key that links to th=
e Contacts table and the field blnPrint.=20

The secondary table is linked to the Contacts table in an Outer join.  This=
produces an un-editable query lists of records. =20

To select the records to print, one clicks on the blnPrint checkbox.  But s=
ince the list is not editable it runs a routine in a field, i think a trans=
parent command button, behind the checkbox.

Why did the programmer do this?  I believe since multiple people may be sel=
ecting records to print, you would not want records I select to be printed =
in the list of records you want to print.  Iow, print the records you selec=
t, not  all of them flagged to print.

This has been a pain in the ass to follow his code and logic.  There are ze=
ro comments in the app so what the person does is ridiculous.  He wrote the=
app like an object oriented java program.

Anyway, is there a way that I can have an easy way to select records to pri=
nt that would not conflict with the records another person might select to =
print?

How can I select the records I want to print that does not get included in =
another users list of records to print.  Any advice gladly accepted.  There=
has too be a better way than the one currently in use,

Thanks.

Replies