Re: [MS_AccessPros] Update a new field having huge data (Access 2007)

 

John,

Structure of table GD-1:

ConsignmentNo-->Text 9

ExporterName-->Text 100-->Row Source-->SELECT ExporterGD1.ExporterName,   ExporterGD1.ExporterTele FROM ExporterGD1 ORDER BY ExporterGD1.ExporterName;

 

PageOfPage-->Text 50

CustomOffice-->Text 50-->Row Source-->SELECT CustomOfficeGD1.CustomOffice FROM CustomOfficeGD1 ORDER BY CustomOfficeGD1.CustomOffice; 

ImporterID-->Integer-->Row Source-->SELECT Importer.ImporterID, Importer.ImporterCountryEnglish, Importer.ImporterTelEnglish FROM Importer ORDER BY Importer.ImporterID;

 

Declarant-->Text 100-->Row Source-->SELECT DeclarantGD1.Declarant,

DeclarantGD1.DeclarantCityCountry, CountryOfDestination-->Text 5-->Row Source-->SELECT DestinationCountryGD1.CountryOfDestination FROM DestinationCountryGD1 ORDER BY DestinationCountryGD1.CountryOfDestination;

 

EFormNo-->Text 50

EFormDate-->Short Date

CurrencyName-->Text50

TotalValueDeclaredUnit-->Text 50

TotalInvoiceValue-->Long Integer

ExchangeRate-->Double,Fixed,4

PortOfShipment-->Text 50

PortOfDischarge-->Text 50

PlaceOfDeleivery-->Text 50

DeliveryTerms-->Text 50

NumberOfPackages-->Long Integer

GrossWeight-->Long Integer

ItemDescription-->Text 50

ItemNo-->Long Integer

NoOfUnits-->Long Integer

ProductID-->Long Integer-->Row Source-->SELECT Products.ProductID, Products.ProductNameEnglish FROM Products ORDER BY Products.ProductID;

UnitValueDeclared-->Number,Single

UnitValueName-->Text 50

TotalValueDeclared-->Long Integer

CustomValuePKR-->Long Integer

------------------------------------------------

Once you gave me structure of a table "ClientConsignments" and it did not have PK, Why ?

Regards,

Khalid

 

---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote :

Yes, you could try another table.

What is the structure of GD-1?  EVERY table should have a Primary Key.

John Viescas, Author

Effective SQL

SQL Queries for Mere Mortals 

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

http://www.viescas.com/ 

(Paris, France)

On Jan 20, 2017, at 11:04 PM, khalidtanweerburrah@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

John,

I don't have any idea which field to make Primary Key in this table. Can I have a try on another table "CollectionVoucher"  having "ConsignmentNo" as PK ?

Regards,

Khalid

---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote :

The table MUST have a Primary Key.

John Viescas, Author

Effective SQL

SQL Queries for Mere Mortals 

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

http://www.viescas.com/ 

(Paris, France)

On Jan 20, 2017, at 10:25 PM, khalidtanweerburrah@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

John, 

Table GD-1 has no Primary key and field ProductID is empty in it, only "ProductNameEnglish" are filled.

Regards,

Khalid

---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote :

Khalid-

Does table GD-1 have a Primary Key?  Before the update, the field ProductID in that table should be empty.

John Viescas, Author

Effective SQL

SQL Queries for Mere Mortals 

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

http://www.viescas.com/ 

(Paris, France)

On Jan 20, 2017, at 10:02 PM, khalidtanweerburrah@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

John,

In table "Products" field "ProductID" is Primary Key, Long Integer, No Duplicates.

In table "GD-1" field "ProductID"  has field size Long Integer, indexed: Yes (DuplicatesOK)

Its Lookup Row Source is:

SELECT Products.ProductID, Products.ProductNameEnglish

FROM Products

ORDER BY Products.ProductID;

As yet i have not removed field "ProductNameEnglish" from table "GD-1"

Regards,

Khalid

__._,_.___

---

Posted by: khalidtanweerburrah@yahoo.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (13)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___