为什么数据库关系字段在表单中没有正确显示？ [英] Why don't the database relationship fields display correctly in the form?

问题描述

我的原始数据库有一个表，其中包含患者信息和最多3个插槽。对于医生要求的程序。我正在研究包含两个表的拆分版本：患者和程序。首先，当我拆分原始数据库时，它不包含自动编号字段，所以我只是允许关系基于患者的图表编号（这是唯一的）。我根据这些新表制作了新表格，一切都很棒。


我的目标一直是使用自动编号来识别患者和作为一对多连接字段，所以今天我在原始数据库中添加了一个自动编号字段，重新加工了我的两个表中的连接（当然还删除了当前的数据），然后将单个表导出到Excel并推送了一些东西，以便我可以导入到两个连接的表中（使用相同的步骤我已经使用过去几周，这是完美的工作）。


但是，现在，患者人口统计数据（图表编号，姓氏等）在我的表单中显示不正确：所有字段都被推到一个地方向右 ;就好像AutoNumber字段将它们推到一边，即使它在任何表单上都没有位置。当我查看数据表中的数据时，一切看起来都不错;没有更改字段名称;在表单中，每个字段的属性表明它们正在从正确的表字段中提取。数据显示在图表编号中。字段（自动编号患者索引字段后面的第一个字段）看起来是一个随机的单字符值。


我无法弄清楚发生了什么。任何想法都将不胜感激。

My original database has a single table which contains Patient information and up to 3 "slots" for procedures requested by the doctor. I am working on a split version that contains two tables: Patients and Procedures. At first, when I split the original database, it contained no AutoNumber field, so I simply allowed the relationship to be based on the patient''s chart number (which is unique). I''ve made my new forms based on those new tables, and everything has been great.

My goal all along, however, was to use an autonumber to identify the patients and as the one-to-many join field, so today I added an AutoNumber field to the original database, reworked the join in my two tables (and deleted the current data, of course), then exported the single table into Excel and shoved things around so that I could import into the two joined tables (using the same steps I''ve been using for the past several weeks, which have worked perfectly).

Now, however, the patient demographic data (chart number, last name, etc.) is being displayed incorrectly in my forms: all the fields are pushed one place "to the right", as though the AutoNumber field is shoving them aside, even though it has no place on any of the forms. When I look at the data in the datasheet, everything looks okay; no field names were changed; and in the forms, the Properties of each field indicate that they are pulling from the correct table field. The data being displayed in the "Chart Number" field (which is the "first" one following the autonumber "Patient Index" field) looks to be a random, single-character value.

I can''t figure out what''s happened. Any ideas will be greatly appreciated.

推荐答案

sueb ，这是我觉得我们能够确切知道什么是/的唯一方法不再继续，通过查看实际的数据库本身，以及所涉及的所有组件的详细说明。您能否以Access 2003格式上传数据库的缩小版本？

sueb, the only way that I feel we can get an idea of exactly what is/is not going on, is by looking at the actual Database itself, along with a detailed explanation of all the components involved. Can you Upload a scaled-down Version of your DB in Access 2003 format?

好的。我将在周一回来工作时这样做。谢谢！

Okay. I''ll do that on Monday when I''m back at work. Thanks!

请确保包含详细说明问题所在的细节以及所涉及的对象。

Just be sure to include the specifics inidicating what, exactly, the problem is, and the Objects involved.

这篇关于为什么数据库关系字段在表单中没有正确显示？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！