在共享表中标记选项 [英] Mark an Option in Shared Tables
问题描述
嘿 -
Hey -
访问2010中的应用程序。获胜7。
Application in access 2010. win 7.
我在应用程序中有联系人列表。
I have a list of contacts in the application.
该应用程序是Tables文件(App + BE)中的单独文件。
The application is seperated file from the Tables file (App + BE).
我有一个表单"联系人"
I have A form "Contacts"
该表格具有绑定控件"bMark",字段为"bMark"。在"联系人"中表。
This form has a bound control "bMark", to a field "bMark" in "Contacts" Table.
现在 - 当一个用户检查10个联系人,并且想要打印他们的卡时 - 和其他用户之一,打开他的应用程序 -
Now - when one user check 10 contacts, and want to print their card - And one of the other users, open his application -
他看到马克,当他检查他的选择时 - 他们的两个选择都被发送到打印。
He see the Mark, and when he checks his choises - Both of their choises are send to print.
我需要分开用户选择。
I need to seperate the users choises.
我认为我将从链接表中导入数据的本地表将给我这个解决方案......它有,但我觉得编程很糟糕......
I thought that a local table, that i will import the data to, from the linked table, will give me this solution... it has, but i think it is bad programing...
另外,我不知道这会让应用更快还是更慢......
Also, I don't know is this will make the application faster or slower...
如果您对此有所了解 - 我会非常满意。
If you have any expirience on that - I would be greatfull.
谢谢!
Alu
Alu_g
推荐答案
您好,
而不是表格中的bMark字段或导入数据您可以使用"选择"表"在你的前端。它将有2个字段:"Id"和"Id"。对应于联系人表格中的唯一字段(可能是PK)和"bMark",
a是/否字段。
instead of the bMark field in the table itself or importing the data you could use a "selection table" in your frontend. It would have 2 fields: "Id" that corresponds to a unique field (possibly the PK) in the contacts table and "bMark", a Yes/No field.
对于您的表单和报表,您可以通过ID选择外部联接(联系表中的所有记录以及仅相应的数据...)来查询查询中的2个表。使用 新的本地 bMark字段来管理选择。
For your form and report you connect the 2 tables in a query via ID choosing an outer join (all records from the contact table and only the corresponding data...). Use the new, local bMark field to manage the selection.
这篇关于在共享表中标记选项的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!